I have a formula that I want to have filled down starting from A2.
Everytime this macro would run, number of rows that would be filled would be
different.

Anyway to have this automated using vba?

you didn't mention what column the last row of data was, so i used B

Option Explicit
Dim lrow As Long
Sub fill()
lrow = Range("B1").End(xlDown).End(xlDown).Row
Range("A2").AutoFill Destination:=Range("A2:A" & lrow)
End Sub
--


Gary


"Dominique Feteau" wrote in message
...
I have a formula that I want to have filled down starting from A2.
Everytime this macro would run, number of rows that would be filled would
be different.

Anyway to have this automated using vba?