Command for present sheet
 

Hi,

I need to know the command to record a sheet to a variable. So i ca
run a macro which will return to the same sheet it started it.

something like:

a = presentSheet.Value

Thx a lo

--
kanuva
-----------------------------------------------------------------------
kanuvas's Profile: http://www.excelforum.com/member.php...fo&userid=2791
View this thread: http://www.excelforum.com/showthread.php?threadid=48481

Command for present sheet
 

Hi Kanuvas,

Try:

Dim Sh as Worksheet

Set Sh = ActiveSheet


---
Regards,
Norman



"kanuvas" wrote in
message ...

Hi,

I need to know the command to record a sheet to a variable. So i can
run a macro which will return to the same sheet it started it.

something like:

a = presentSheet.Value

Thx a lot


--
kanuvas
------------------------------------------------------------------------
kanuvas's Profile:
http://www.excelforum.com/member.php...o&userid=27911
View this thread: http://www.excelforum.com/showthread...hreadid=484816

Command for present sheet
 

Thank you for the quick response

Using that how do i then select that sheet

something like:

sh.select


--
kanuvas
------------------------------------------------------------------------
kanuvas's Profile: http://www.excelforum.com/member.php...o&userid=27911
View this thread: http://www.excelforum.com/showthread...hreadid=484816