VBA : having certain cell in same place when sheet is activa

bearcub · Feb 20th 2004

I want to write code in the Worksheet Activate event.

What I want to happen is have cell AY133, for example, always be the first cell shown in the left hand corner (it happens to be the company name).

When I just write code (Range("AY133").select) it doesn't always make the cell the top left cell.

What code to I have to add to make sure this section is always shown?

thanks

Anonymous · Feb 20th 2004

Add to your Activate code
With ActiveWindow
.ScrollRow = 133
.ScrollColumn = 51
End With

Ivan F Moala · Feb 20th 2004

or just

Code

Application.Goto Reference:=ActiveSheet.Range("AY133"), Scroll:=True

Participate now!