Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with subscript error
Hi,
Without seeing the line of code that fails it's difficult to be precise but subscript out of range means (for example) your refererring to an object that isn't there Sheets("Sheet4").Range("A1").Value = 1 Gives subscript out of range if there isn't a sheet4. Mike "Paolo" wrote: I have 6 worksheets with VBA code to create a months worth of worksheets using 4 templates. I made some changes to the code and now I get runtime error 9 subscript out of range. Each worksheets templates are different slightly. It works on all but two. Any help is appreciated. Can send code but it needs the templates to work. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
runtime error 9, subscript out of bounds error #2 | Excel Programming | |||
Runtime Error - Subscript out of range despite On Error statement | Excel Programming | |||
Subscript out of range error - save copy error | Excel Programming | |||
Subscript out of range error - save copy error | Excel Programming | |||
Type Mismatch error & subscript out of range error | Excel Programming |