| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Next Sheet
Hi to all
I'm trying to get to my next sheet and at the same time go to the top of the sheet. I have the following code: ' Go to Sheet2 Sheets("Sheet2").Select This takes me to Sheet2, now how do I get to A1? Thans for your help. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Next Sheet
Ren,
Try something like Application.Goto Worksheets("Sheet2").Range("A1"), True -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Ren" wrote in message ... Hi to all I'm trying to get to my next sheet and at the same time go to the top of the sheet. I have the following code: ' Go to Sheet2 Sheets("Sheet2").Select This takes me to Sheet2, now how do I get to A1? Thans for your help. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Next Sheet
Hi
try adding the line Application.Goto Reference:=activesheet.Range("a1"), Scroll:=True -- Regards Frank Kabel Frankfurt, Germany Ren wrote: Hi to all I'm trying to get to my next sheet and at the same time go to the top of the sheet. I have the following code: ' Go to Sheet2 Sheets("Sheet2").Select This takes me to Sheet2, now how do I get to A1? Thans for your help. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Next Sheet
range("A1").select
"Ren" wrote in message ... Hi to all I'm trying to get to my next sheet and at the same time go to the top of the sheet. I have the following code: ' Go to Sheet2 Sheets("Sheet2").Select This takes me to Sheet2, now how do I get to A1? Thans for your help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel sheet bootom half sheet goes behind top part of sheet | Excel Worksheet Functions | |||
| Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
| How do I select price from sheet.b where sheet.a part no = sheet.b | Excel Worksheet Functions | |||
| relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
| Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B | Excel Programming | |||
Linear Mode
