Posted to microsoft.public.excel.programming

pwz

external usenet poster

Posts: 5

Array error

Hello All,

I have encountered the following error message:

Run-time error '9'
Subscript out of range

sName1 = sh.Name & " Hi"
sName2 = sh.Name & " Hello"
Sheets(Array(sName1, sName2)).Copy

The copy statement works if I replace the variables with actual sheet name.
May anyone give some hints to me? Thanks in advance!

Regards,

PW

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
Array Formula Error	CecesWorking	Excel Worksheet Functions	5	January 26th 09 08:43 PM
#Num error in Array	Ben Dummar	Excel Discussion (Misc queries)	6	June 29th 06 02:22 AM
Array Calculation Error	Tobro88	Excel Worksheet Functions	12	December 5th 05 03:50 PM
array error	BorisS	Excel Discussion (Misc queries)	5	November 8th 05 04:03 PM
Array error	Craig[_2_]	Excel Programming	2	July 4th 05 06:15 PM

All times are GMT +1. The time now is 11:41 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us