Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subscript out of range when adding worksheet
Using Excel 97 to 2003.
I have an add-in that somewhere has to add a worksheet after the last sheet. This goes with: ActiveWorkbook.Sheets.Add _ After:=Worksheets(ActiveWorkbook.Sheets.Count) This goes fine with all the users of the add-in, except one person, who gets the error: Subscript out of range at this line. I have tried all kind of manipulations such as deleting, moving, renaming and hiding of the sheets, but I just can't reproduce this error. Protecting the workbook will cause a different error. I am just puzzeled what could be causing this error. Any advice greatly appreciated. RBS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subscript out of Range | Excel Discussion (Misc queries) | |||
what does 'Subscript Out of range' mean?? | Excel Worksheet Functions | |||
9: Subscript out of range | Excel Discussion (Misc queries) | |||
Subscript our of range when activating a worksheet | Excel Programming | |||
Subscript Out of Range | Excel Programming |