Filldown Formula

[KWhamill]

I'm looking for a foolproof technique to Filldown a formula when I don't know
in advance how many rows i might have to fill. However, the column
Immediately to the left will be populated when the formula is applied. Any
suggestions would be great.
Thanks,
K

 

[Mike H]

Hi,

Select the cell you want to fill-down and you will see a black square on the
bottom right. Double click it and the column will down as far as the
populated range in the column to the left.

Mike

 

[Rick Rothstein \(MVP - VB\)]

If there are no empty cells between the first and last cells in the column
to the left, then select the cell with your formula in it and double-click
the small black square in the bottom right corner of the selection border.

Rick

 

[KWhamill]

well thanks yes, I actually I knew that. but that's Ok cause I figured it
out. I was looking for this:

Range("D2" & Range("C65536").End(xlUp).Row).FormulaR1C1 = _
"=ABS(RC[10])/1000000"

Not perfect but it works fine. I would like to make it specific to the data
so if someone gets the bright idea to move the column (or maybe I should say
'when') the Macro will work even if i am not there to fix it. Thank you