Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Errors in 2007
I developed an Excel Workbook that has VBA to automate certain processes. It
works without any issue in 2003. Now we have moved to 2007 and for an unknown reason the code now spits out 'error: 9', several times. The code still run and the result is correct?! Should I simply ignore the error statements or should they be adressed? Is this a known issue by any chance or do I need to rip apart my code to resolve it? Thank you for your advice, QB |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Errors in 2007
That error 9 (Subscript out of range) usually shows up when you refer to
something that doesn't exist. Like: worksheets("sheet999").cells.clear if there was no sheet named 999 in the activeworkbook. I wouldn't ignore the problem. But I would try to isolate the lines causing the trouble (maybe step through the code???). I wouldn't think of it as ripping apart your code--more like a surgical strike. QB wrote: I developed an Excel Workbook that has VBA to automate certain processes. It works without any issue in 2003. Now we have moved to 2007 and for an unknown reason the code now spits out 'error: 9', several times. The code still run and the result is correct?! Should I simply ignore the error statements or should they be adressed? Is this a known issue by any chance or do I need to rip apart my code to resolve it? Thank you for your advice, QB -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA errors in 2007 (works fine in 2003) | Excel Discussion (Misc queries) | |||
Rounding Errors in 2007 | Excel Worksheet Functions | |||
excel 2007 getting errors with mround | Excel Worksheet Functions | |||
print errors excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 charting errors with pivot tables | Charts and Charting in Excel |