Making desired row the first displayed
 

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

Many thanks.

Making desired row the first displayed
 

ctrl+home

use this to goto a specific
application.goto range("a22"),true

--
Don Guillett
SalesAid Software

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

Many thanks.

Making desired row the first displayed
 

On Sat, 15 May 2004 12:21:52 -0500, "Don Guillett" wrote:

application.goto range("a22"),true

Works great. Thanks.

Making desired row the first displayed
 

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



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

Many thanks.

Making desired row the first displayed
 

glad to help


--
Don Guillett
SalesAid Software

wrote in message
...
On Sat, 15 May 2004 12:21:52 -0500, "Don Guillett"
wrote:

application.goto range("a22"),true

Works great. Thanks.