Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
2003 to 2007 updates
I saved my old 2003 excel macro program (.xls) as the 2007 macro enabled
version (.xlsm). I wen through the program and changed to run commands to open the appropriate document and run from the appropriate databases. Now, the program gets to a certain point and says that the subscript is out of range. This is the program: Sub GEN_DATA() 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXX 'This generates all of the data as well as make all of the colums and 'sort data for the charts. '-------------------------------------------------------------------------- Sheets("myVar1").Select Application.ScreenUpdating = False The "Sheet("myVar1").Select is what is causing my error. Any thoughts?? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
2003 to 2007 updates
That means that there is no sheet named myVar1.
Did you really mean: sheets(myvar1).select ???? playerbigdog wrote: I saved my old 2003 excel macro program (.xls) as the 2007 macro enabled version (.xlsm). I wen through the program and changed to run commands to open the appropriate document and run from the appropriate databases. Now, the program gets to a certain point and says that the subscript is out of range. This is the program: Sub GEN_DATA() 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXX 'This generates all of the data as well as make all of the colums and 'sort data for the charts. '-------------------------------------------------------------------------- Sheets("myVar1").Select Application.ScreenUpdating = False The "Sheet("myVar1").Select is what is causing my error. Any thoughts?? -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
2003 to 2007 updates
I just changed it to without the quotes and it is running so far. Thanks for
the quick fix!! "Dave Peterson" wrote: That means that there is no sheet named myVar1. Did you really mean: sheets(myvar1).select ???? playerbigdog wrote: I saved my old 2003 excel macro program (.xls) as the 2007 macro enabled version (.xlsm). I wen through the program and changed to run commands to open the appropriate document and run from the appropriate databases. Now, the program gets to a certain point and says that the subscript is out of range. This is the program: Sub GEN_DATA() 'XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX XXXXXXXXXXXXXXXXXXXXXXXXX 'This generates all of the data as well as make all of the colums and 'sort data for the charts. '-------------------------------------------------------------------------- Sheets("myVar1").Select Application.ScreenUpdating = False The "Sheet("myVar1").Select is what is causing my error. Any thoughts?? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link updates Excel 2007 | Excel Worksheet Functions | |||
Excel 2003-installing security updates | Setting up and Configuration of Excel | |||
MS Office 2003 updates have screwed up Excel ! | Excel Discussion (Misc queries) | |||
Excel Links Updates in 2003 | Excel Worksheet Functions | |||
Excel 2003 Updates, and Errors | Setting up and Configuration of Excel |