Using macro to select a range

[Guest]

Hello,
I am looking for help to setup a simple macro to navigate to a specific
range in excel. Specifically, I need the macro to move to a specific cell,
but move the cell to the top of the screen so everything is visible below the
selected cell.
Currently, I have a simple macro but it shows the cell in the middle of the
screen, cutting off data below.

 

[Paul B]

Rob, maybe add something like this to the macro, will put A154 at the top
left

Application.Goto Reference:=Worksheets("Sheet1").Range("A154"), _
scroll:=True

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Guest]

Thank you. That worked perfectly.

Rob, maybe add something like this to the macro, will put A154 at the top
left

Application.Goto Reference:=Worksheets("Sheet1").Range("A154"), _
scroll:=True

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Paul B]

Your Welcome, thanks for the feedback
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003