Posted to microsoft.public.excel.programming

external usenet poster

Posts: 699

subscript out of range error: tyring to copy a hidden sheet

I got a subscript out of range error when trying to copy sheet2. Sheet2 is
hidden.

here is the code:

Worksheets("Hidden").Copy Worksheets("Sheet2")

Thanks in advance

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
subscript out of range error: tring to copy a hidden sheet	sam	Excel Programming	1	August 7th 09 11:48 PM
Subscript out of range error - selecting a sheet	John[_140_]	Excel Programming	3	August 3rd 09 12:35 AM
Subscript out of range error - save copy error	bg18461[_16_]	Excel Programming	2	June 13th 06 04:53 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

All times are GMT +1. The time now is 03:25 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us