Try this

Will FillDown b1:d1 till the last row with data in column A

Sub test()
Dim a As Long
a = Range("A" & Rows.Count).End(xlUp).Row
Range("B1:D" & a).FillDown
End Sub


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Max Velocity" wrote in message ...

Hi everyone,

I beleive this is a relatively simple question, but it is frustrating
me a lot. I would like to use the simplest possible macro to fill a
number of specified columns with data. I always know which row the data
should begin in. I would like to feed off another column in the same
sheet for my range, but data in this column fluctuates. Should I use an
IfEmpty function...? If so how would you write it?

Cheers!

Max


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/