Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Last week some nice folks here gave me a few tips, and I was able to get
the macro I had been working on to run properly. Thanks! But today, I ran the same macro on a worksheet that was laid out exactly like the earlier one, and I got `Subscript Out Of Range.' error. I made no chages to the code. Here is the line that program stopped at: FullName = Worksheets("Sheet1").Cells(I, 4).Value I thought maybe the error was caused because the macro was not actually in the workbook I was using. I copied it to that workbook, but same thing happened. Anybody have any idea?? Sam A man who had lately declared That property ought to be shared, Thought it going too far When they called for his car, And a list of exceptions prepared. Thomas Thorneley, From The Penguin Book Of Limericks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Subscript out of range | Excel Discussion (Misc queries) | |||
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 Out of Range | Excel Programming |