Go to sheet2

[hme]

Hi

What is the code to shift from shee1 to sheet2?
The code is in sheet1 and I would like to change somthing in sheet2.

Thanks
hme

[Norman Jones]

Hi Hme,

> What is the code to shift from shee1 to sheet2?

Sheets("Sheet2").Select

However, it is rarely necessary to make selections. Values can be changed on
a non-active sheet. For example:

Sheets("Sheet2").Range("A1").Value = 100


---
Regards,
Norman



"hme" <[email protected]> wrote in message
news:[email protected]...
>
> Hi
>
> What is the code to shift from shee1 to sheet2?
> The code is in sheet1 and I would like to change somthing in sheet2.
>
> Thanks
> hme
>
>
> --
> hme
> ------------------------------------------------------------------------
> hme's Profile:
> http://www.excelforum.com/member.php...o&userid=15930
> View this thread: http://www.excelforum.com/showthread...hreadid=538355
>