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