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

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

As ALWAYS, post your coding efforts for comments

--
Don Guillett
SalesAid Software

"agentsmith83"
wrote in message
news:agentsmith83.26h03m_1145381103.4764@excelforu m-nospam.com...

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

Is your code in a General module or is it behind a worksheet?

Unqualified ranges refer to the activesheet in a General module.

Unqualified ranges refer to the sheet owning the code if its in a worksheet
module.

That said, selecting a range isn't usually required to work on it.

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

--

Dave Peterson