I just tested your code, as written to 2000 and it worked fine but this idea
might be better.

Sub filldown()
Range("x2:ao2").AutoFill Range("x2:ao1000")
End Sub

--
Don Guillett
SalesAid Software

"Jason" wrote in message
...
Greetings,

Below are a couple of lines from some code I am running. When the code
reaches the Autofill line, it runs the code (autofill takes place), but
then
the code just stops (doesn't proceed to the next line of code) and reverts
back to the beginning of the sub. I've tried stepping through this, so I
know exactly where it is happening, but I can't figure out why? I have
the
same type type of code in a different workbook and it works fine. Any
ideas?
Thanks.

Range("X2:AO2").Select
Selection.AutoFill Destination:=Range("X2:AO1000")