Posted to microsoft.public.excel.programming

John[_140_] John[_140_] is offline

external usenet poster

Posts: 57

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Copying Sheet - subscript out of range error	GSP@DCS	Excel Programming	1	August 2nd 06 01:56 AM
Runtime Error - Subscript out of range despite On Error statement	DoctorG	Excel Programming	3	July 28th 06 03:56 PM
Subscript out of range error - save copy error	bg18461[_15_]	Excel Programming	1	June 13th 06 04:36 PM
In multiple sheet copy error subscript out of range ?? HELP	Eddy Stan	Excel Programming	4	March 22nd 06 04:54 AM
Type Mismatch error & subscript out of range error	Jeff Wright[_2_]	Excel Programming	3	May 14th 05 07:14 PM

All times are GMT +1. The time now is 12:17 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us