Macro to insert formula result into range with zero values in cell

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I have a column with possible Values A thru F for example. I need to insert
any of A thru F (whatever is there) into another range where there are cells
equal to zero in that range (column). There can only be one copy of A thru F
in the new range. Please help if you can, I am blocked on this project. I
appreciate any help given. If this is more appropriate in worksheet
functions, please advise. Posted only in programming.

Thanks
.

Relevant Pages

  • Re: Tally chart cells exist in Excel!??
    ... Yeah =lenworks very well indeed... ... programming the worksheet i think right?... ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: Dont want #VALUE! in cells
    ... rm@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx (Roger Morris) wrote: ... > I have a worksheet in which col B contains text. ... > I would rather that SEARCH gave a 0 (zero) answer if the searched-for ... Prev by Date: ...
    (microsoft.public.mac.office.excel)
  • countif
    ... I have a summarizing section of a worksheet in which I need to get an average ... I need to put a condition on it that the average is based on only the cells ... This only says if N13 is greater than zero, but I have all the other cells ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Finding the first blank or zero value
    ... I am trying to find a way to locate which column the first blank or zero ... value appears in my worksheet. ... together without success. ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Excel 2000 Solver Problems
    ... both with programming it and using it in the worksheet. ... related kb article saying that it needed a hotfix, ... Prev by Date: ...
    (microsoft.public.excel.programming)