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.

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

"Rob" wrote in message
...
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.

Thank you. That worked perfectly.

"Paul B" wrote:

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

"Rob" wrote in message
...
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.

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

"Rob" wrote in message
...
Thank you. That worked perfectly.

"Paul B" wrote:

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

"Rob" wrote in message
...
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.