Using macro to select a range

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rob - 06 Nov 2006 18:29 GMT

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.

Reply to this Message

Paul B - 06 Nov 2006 18:41 GMT

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

Signature

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

> Hello,
> I am looking for help to setup a simple macro to navigate to a specific
[quoted text clipped - 5 lines]
> the
> screen, cutting off data below.

Reply to this Message

Rob - 06 Nov 2006 20:07 GMT

Thank you. That worked perfectly.

> Rob, maybe add something like this to the macro, will put A154 at the top
> left
[quoted text clipped - 11 lines]
> > the
> > screen, cutting off data below.

Reply to this Message

Paul B - 06 Nov 2006 20:31 GMT

Your Welcome, thanks for the feedback

Signature

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

> Thank you. That worked perfectly.
>
[quoted text clipped - 15 lines]
>> > the
>> > screen, cutting off data below.

Reply to this Message