Hi,

I know this is most likely pretty easy, but it's killing me! Using VBA, I
need to copy the formulas in Cells AA8, AB8 & AC8 all the way to the bottm of
there respective columns as long as there's data in cell "D" of the previous
row. Any help would be much appreciated.

Thanks

as long as there's data in cell "D" of the previous row.

Huh? Maybe you can rephrase.

--
Jim
"Phil" wrote in message
...
| Hi,
|
| I know this is most likely pretty easy, but it's killing me! Using VBA, I
| need to copy the formulas in Cells AA8, AB8 & AC8 all the way to the bottm
of
| there respective columns as long as there's data in cell "D" of the
previous
| row. Any help would be much appreciated.
|
| Thanks
|

One possible interpretation:

set rng = Range(Cells(8,"D"),Cells(rows.count,"D").End(xlup) )
rng.offset(0,26).Formula = Range("AA8").Formula
rng.offset(0,27).Formula = Range("AB8").Formula
rng.offset(0,28).Formula = Range("AC8").Formula


"Phil" wrote in message
...
Hi,

I know this is most likely pretty easy, but it's killing me! Using VBA, I
need to copy the formulas in Cells AA8, AB8 & AC8 all the way to the bottm
of
there respective columns as long as there's data in cell "D" of the
previous
row. Any help would be much appreciated.

Thanks

Hi,

Thanks Tom, that work great!

Phil