Thread: Subscript out of range error - selecting a sheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John[_140_] John[_140_] is offline
external usenet poster
  
Posts: 57
Default Subscript out of range error - selecting a sheet
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. "


Reply With QuoteReply With Quote