Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Termintes
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") |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Termintes
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") |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Termintes
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") |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Code Termintes
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
Shorten code to apply to all sheets except a few, instead of individually naming them, and later adding to code. | Excel Programming | |||
Protect Sheet with code, but then code will not Paste error. How do i get around this. Please read for explainations.... | Excel Programming | |||
How to assign same code inside Option button code space ?? | Excel Programming | |||
Excel code convert to Access code - Concat & eliminate duplicates | Excel Programming |