Excel Filldown problem

[Phil]

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

[Jim Rech]

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

Huh? Maybe you can rephrase.

--
Jim
"Phil" <[email protected]> wrote in message
news:[email protected]...
| 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
|

[Tom Ogilvy]

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>

[Phil]

Hi,

Thanks Tom, that work great!

Phil