Making desired row the first displayed

G

Guest

How can I mare row n be the first row displayed (after any "freeze frame"
row(s))?

Many thanks.
 
J

JMay

Sub Macro1() ' Will freeze Column A and rows1-6
' Macro1 Macro
' Macro recorded 5/15/2004 by James May

Range("B7").Select
ActiveWindow.FreezePanes = True
End Sub
 
Top