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?? |
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 |