Command for present sheet

[kanuvas]

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

[Norman Jones]

Hi Kanuvas,

Try:

Dim Sh as Worksheet

Set Sh = ActiveSheet


---
Regards,
Norman



"kanuvas" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[kanuvas]

Thank you for the quick response

Using that how do i then select that sheet

something like:

sh.select