Worksheet activate question

[ipbr21054]

Morning,

I have this is place at present.

Private Sub Worksheet_Activate()
    Range("G13").Activate
End Sub

How can it be changed so i also see the 12 rows before it on the page.
I mean sometimes even though cell G13 is selected its could be 1 inch down from the top of the page & i then need to scroll the page as the rows 12,11,10,9 etc etc is off the page.

Basically i need cell G13 selected BUT i need to have rows 1-12 also within view

thanks

 

[RoryA]

Add:

   ActiveWindow.ScrollRow = 1

to the start of the routine.

 

[ipbr21054]

Thanks very much