Making desired row the first displayed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Many thanks.
 
ctrl+home

use this to goto a specific
application.goto range("a22"),true
 
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
 
glad to help


--
Don Guillett
SalesAid Software
(e-mail address removed)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
Array Formula In IF Function 0
Run-time error when copying entire row! 5
Freezing Header Row 3
Find value in a column and insert rows above 12
Help: Find Matching Cells, If - Then Move Cell With Self 2
special filter or query 1
Excel Moving data to sheet2 from sheet1 0

Back
Top