Wait there's more ... I want the cell reference to change as that formula is
being copied down the column. How can I write that in to the formula?


"FSt1" wrote:

hi
post your code

Regards
FSt1

"Mark Lucas" wrote:

I am attempting to use a macro to write a formula in to a blank cell. When
the formula is written, the cell reference in the formula has apostrophes
around it so it won't function. I'm sure there is a syntax step I'm missing.
Can someone help??