Using macro to select a range
 

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.

Using macro to select a range
 

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.

Using macro to select a range
 

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.

Using macro to select a range
 

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.