Jim posted this to a similar question. I have copied his post to this reply.
------------------------------------------------------------------------
There are many way to do that. Here's one:

Range("B1", Range("B1").End(xlDown)).Offset(0, 1).FillDown

--
Jim Rech
Excel MVP
------------------------------------------------------------------------

"Mike Fogleman" wrote in message
...
I have a formula that needs to be copied down column E alongside imported
data in column D. The number of rows that the imported column D has varies
with each import. How can I set my fill-down rows for the formula to match
up with column D?