| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Go to sheet2
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Go to sheet2
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy data from sheet2 to sheet1 when sheet2 has variable # of rows | Excel Discussion (Misc queries) | |||
| macro to print sheet2 without open sheet2 | Excel Discussion (Misc queries) | |||
| how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+ | Excel Discussion (Misc queries) | |||
| go to sheet1 to sheet2 | Excel Programming | |||
| first name and a second name - In Sheet2 I only need the first name | Excel Programming | |||
Linear Mode
