Subscript out of range error - selecting a sheet
Where is the code located?
The codenaem of the sheet cannot be changed it is read only. It is usually
Sheet1 and in the VBA project window would be the name not in parenthesis.
To access by code name would be someithing like this
Dim c as integer
c = 1
sheets1.select
If you are using the sheet name in parenthesis then you must have the name
typed incorrectly. You could have extra spaces on the tab which may be
causing the problem.
"John" wrote:
Why does this fail? The codename for my sheet is wsh1:
Dim c as integer
c = 1
sheets ("wsh" & c).select
It fails with the error message "subscript out of range. "
|