Matthew Dyer used his keyboard to write :
There may be an easier workaround... This workbook will ALWAYS have
one sheet in it named rwservlet. Is there a way to activate just that
sheet without having to reference the workbook it is in, since that
name is subject to change?

No! You must always use fully qualified refs.

You may be able to set an object variable to that sheet when it's the
active sheet at some point prior.

Example:
In the declarations section of a standard module:
Dim wksServlet As Worksheet

In some procedure that opens the workbook containing this sheet:
Set WksServlet = ActiveSheet

To ref it later on:
WksServlet.Activate

OR
just act directly on the sheet without activating it at all:
WksServlet.Range("A1").Value = 123

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc