Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Going to a specific cell
I want to have a macro that's goes to a specific part of the spreadsheet -
for example BB1. But I want BB1 to be in the left corner of the window. If I just Select the cell it might not do that. How do I go to that cell and ensure that the window is correct - the cells to the left of BB1 are not visible. Thanks for any help on this. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Going to a specific cell
Try this...
Press F5 and in "reference:" type BB1 and give ok or Enter. The Cursor will be moved in BB1 cell. Like that type your cell reference to move to that particular cell. -------------------- (Ms-Exl-Learner) -------------------- "dhstein" wrote: I want to have a macro that's goes to a specific part of the spreadsheet - for example BB1. But I want BB1 to be in the left corner of the window. If I just Select the cell it might not do that. How do I go to that cell and ensure that the window is correct - the cells to the left of BB1 are not visible. Thanks for any help on this. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Going to a specific cell
Thanks for the response - but that doesn't work. Depending on what the user
has been doing and where the cursor is etc. there may be other cells visible to the left of BB1 and that's what I'm trying to solve. David "Ms-Exl-Learner" wrote: Try this... Press F5 and in "reference:" type BB1 and give ok or Enter. The Cursor will be moved in BB1 cell. Like that type your cell reference to move to that particular cell. -------------------- (Ms-Exl-Learner) -------------------- "dhstein" wrote: I want to have a macro that's goes to a specific part of the spreadsheet - for example BB1. But I want BB1 to be in the left corner of the window. If I just Select the cell it might not do that. How do I go to that cell and ensure that the window is correct - the cells to the left of BB1 are not visible. Thanks for any help on this. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Going to a specific cell
Try the below...Use the smallscroll and LargeScroll properties of the
ActiveWindow and adjust to suit.. Range("BB1").Activate ActiveWindow.SmallScroll ToRight:=10 If this post helps click Yes --------------- Jacob Skaria "dhstein" wrote: I want to have a macro that's goes to a specific part of the spreadsheet - for example BB1. But I want BB1 to be in the left corner of the window. If I just Select the cell it might not do that. How do I go to that cell and ensure that the window is correct - the cells to the left of BB1 are not visible. Thanks for any help on this. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Going to a specific cell
Application.Goto reference:=Range("bb1"), scroll:=True
"dhstein" wrote: I want to have a macro that's goes to a specific part of the spreadsheet - for example BB1. But I want BB1 to be in the left corner of the window. If I just Select the cell it might not do that. How do I go to that cell and ensure that the window is correct - the cells to the left of BB1 are not visible. Thanks for any help on this. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Going to a specific cell
Thanks that did it.
"Atishoo" wrote: Application.Goto reference:=Range("bb1"), scroll:=True "dhstein" wrote: I want to have a macro that's goes to a specific part of the spreadsheet - for example BB1. But I want BB1 to be in the left corner of the window. If I just Select the cell it might not do that. How do I go to that cell and ensure that the window is correct - the cells to the left of BB1 are not visible. Thanks for any help on this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not allowing to continu unless a specific cell has specific answer | Excel Discussion (Misc queries) | |||
Link to specific cell in specific Excel file | Excel Discussion (Misc queries) | |||
Link from a specific Cell in Excel to a specific para. in Word | Excel Worksheet Functions | |||
Highlight a row if a specific cell is specific numbers/words | Excel Worksheet Functions | |||
How do I make a cell date specific to input a value on a specific. | Excel Discussion (Misc queries) |