By default it uses the active sheet. That being said you should post some of
the code that is causing you the problem so that we can let you know why it
is doing what it is doing...
--
HTH...

Jim Thomlinson


"agentsmith83" wrote:


General question: When you refer to a range without specifying a
worksheet, what worksheet is used by default?

I'm finding that I select a worksheet, and when I try to select a
range, it goes to the cells in a different worksheet.


Thanks,
Chris


--
agentsmith83
------------------------------------------------------------------------
agentsmith83's Profile: http://www.excelforum.com/member.php...o&userid=33600
View this thread: http://www.excelforum.com/showthread...hreadid=533840