| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning Desired Results | Excel Discussion (Misc queries) | |||
| Meeting desired Targets | Excel Discussion (Misc queries) | |||
| CUSTOM FUNCTION DESIRED | Excel Discussion (Misc queries) | |||
| IRR desired return | Excel Worksheet Functions | |||
| Simplicity is Desired | Excel Worksheet Functions | |||
Linear Mode
