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

[Russ3Z]

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

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP

 

[Russ3Z]

Gord,

Thank you for the quick reply. It worked perfectly.

Russ

 

[Gord Dibben]

Thanks for the feedback.

Gord