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")

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
(E-Mail Removed)
"Jason" <(E-Mail Removed)> wrote in message
news:E7514568-B4F9-4112-AEF4-(E-Mail Removed)...
> 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")

Do you have a worksheet change event that runs, or something similar?

If so you'll need to add
application.enableevents = false
before the lines then
application.enableevents = true
after.
--
JNW


"Jason" wrote:

> 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")

Hi ,

How is everything going? Please feel free to let me know if you need any
assistance.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.