Make Excel view show active cell in top left with VBA?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Russ3Z - 09 Jun 2007 05:10 GMT

I am using a vba macro to go to various ranges on a sheet. When the
range is selected, I would like for Excel to align the top left cell
of the range to be the top left cell in the view.

So, whether I select cell A5 or cell A127, for instance, I want that
cell to be at the top left corner of the current view.

Thanks,
Russ

Reply to this Message

Gord Dibben - 09 Jun 2007 05:27 GMT

Application.Goto Reference:=ActiveCell, Scroll:=True

Gord Dibben MS Excel MVP

>I am using a vba macro to go to various ranges on a sheet. When the
>range is selected, I would like for Excel to align the top left cell
[quoted text clipped - 5 lines]
>Thanks,
>Russ

Reply to this Message

Russ3Z - 09 Jun 2007 05:43 GMT

Gord,

Thank you for the quick reply. It worked perfectly.

Russ

Reply to this Message

Gord Dibben - 09 Jun 2007 05:45 GMT

Thanks for the feedback.

Gord

>Gord,
>
>Thank you for the quick reply. It worked perfectly.
>
>Russ

Reply to this Message