Copy Formula

[thecabledog]

need a tip to copy a formula.

if F7 > 0 then
copy formula in G6 and paste in G7

CATCH...

i need to do this for everything in the F column. So if there is anything in f7:f65536 then it will put a formula in the coresponding G columns. If not then it will stay blank.

can anyone give suggestions?

 

[PHV]

Have you tried the macrorecorder to get a starting point ?
You may also have a look in the FAQ area to discover 2 methods for retrieving the last row number of a column.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886