Using macro to select a range

R

Rob

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.
 
P

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
 
R

Rob

Thank you. That worked perfectly.

Paul B said:
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
Click to expand...
 
P

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
 
Top