have you tried adding

Dim ws as worksheet
ws=sheets("Middle Sheet").Range("C1").value
ws.select

"kyle" wrote:

That would work except the people using the sheet need to be able to add
sheets, so I would not be able to reference. Could I create a prompt and
have the user type in the head name?

"Kaak" wrote:


Sheets have a TAB name and a Code name.
The code name can only be changed in the VBE.

So you should use that name to reference your sheet.


--
Kaak
------------------------------------------------------------------------
Kaak's Profile: http://www.excelforum.com/member.php...fo&userid=7513
View this thread: http://www.excelforum.com/showthread...hreadid=557001