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" wrote in message
...

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