| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
moving to aparticular view - SOUNDS SIMPLE?!
maybe this is very simple, but its got me!
I have a list 5000 rows long in sheet2. Sheet1 has a cell which says a cell address e.g A2563, and a command button called View. When I hit the button I want to activate sheet2 (easy), select A2563 (easy) and be able to see what is in cell A2563. At the moment its jumping to sheet2 and selecting the cell ok but I'm still left viewing range("A1") and the top of the spreadsheet on my screen!! Is there a property of range("A2563") which will let me scoll the correct amount so that its in view - or am I just missing something obvious! Help greatly appreciated. Jason |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
moving to aparticular view - SOUNDS SIMPLE?!
Application.Goto Reference:=Worksheets("Sheet2").Range("A2563"), _
Scroll:=True -- Regards, Tom Ogilvy "jason" wrote in message om... maybe this is very simple, but its got me! I have a list 5000 rows long in sheet2. Sheet1 has a cell which says a cell address e.g A2563, and a command button called View. When I hit the button I want to activate sheet2 (easy), select A2563 (easy) and be able to see what is in cell A2563. At the moment its jumping to sheet2 and selecting the cell ok but I'm still left viewing range("A1") and the top of the spreadsheet on my screen!! Is there a property of range("A2563") which will let me scoll the correct amount so that its in view - or am I just missing something obvious! Help greatly appreciated. Jason |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
moving to aparticular view - SOUNDS SIMPLE?!
Cheers Tom
One of those non-intuitive ones (would have thought it would of atleast had "select" or "activate" in the answer) Jason. "Tom Ogilvy" wrote in message ... Application.Goto Reference:=Worksheets("Sheet2").Range("A2563"), _ Scroll:=True -- Regards, Tom Ogilvy "jason" wrote in message om... maybe this is very simple, but its got me! I have a list 5000 rows long in sheet2. Sheet1 has a cell which says a cell address e.g A2563, and a command button called View. When I hit the button I want to activate sheet2 (easy), select A2563 (easy) and be able to see what is in cell A2563. At the moment its jumping to sheet2 and selecting the cell ok but I'm still left viewing range("A1") and the top of the spreadsheet on my screen!! Is there a property of range("A2563") which will let me scoll the correct amount so that its in view - or am I just missing something obvious! Help greatly appreciated. Jason |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to validate characters within a string of data in aparticular cell | Excel Discussion (Misc queries) | |||
| Simple? View named range from sheet1 on sheet2 | Excel Worksheet Functions | |||
| Sounds simple but isn't - displaying cell text | Excel Worksheet Functions | |||
| It sounds simple but i would really appreciate some help linking r | Excel Discussion (Misc queries) | |||
| How can i calculate the age as on aparticular date on excel | Excel Worksheet Functions | |||
Linear Mode
