No problem. There's always a time lag between loading the messages, reading,
and responding.

And I think it helps--sometimes it gives alternative suggestions to solve the
same challenge.

Norman Jones wrote:

Hi McCrimmon,

Dave has already responded to your problem but, unless my selective
blindness is even more pronounced than normal, it was not there when *I*
replied.

Sorry Dave!

---
Regards,
Norman

"Norman Jones" wrote in message
...
Hi McCrimmon,

The error indicates that one of the sheets whose names is included in:

Arr = Array("Day1", "Day2", "Day3", "Day4")

has not been found.

Check the names and, if necessary, look for initial, traling or
intermrdiate spaces.

If you check the value of i when the error occurs, it will point you to
the problematic sheet name. Bear in mind that the array is 0-based, so if
the error occurs when (say) i = 1, you should check for the presence of a
sheet named "Day2" (i.e, the 2nd array element). To check the value of i,
set a watch on it in the VBE.

I have a working test book if you would like it.

---
Regards,
Norman



"mccrimmon" wrote
in message ...

with doing all of the above i seem to be getting a runtime error "9":
subscript out of range

The reference it relates to seems to be:

Set sh2 = Sheets(Arr(i))

Any suggestions?


--
mccrimmon


------------------------------------------------------------------------
mccrimmon's Profile:
http://www.excelforum.com/member.php...fo&userid=6338
View this thread:
http://www.excelforum.com/showthread...hreadid=391474




--

Dave Peterson