Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
freeze pane command usage (clarified)
just plain old stuck on this one...
How would I go about freezing the view of my active window at D4, with B2 at the top left corner of the screen (first visible row, top row = 2, first visible column, left -most column = col B) ? clarification: i'm looking for a way to do this with code, knowing that the active cell might be anywhere on the sheet (although, after i do all of this "stuff", the active cell would be in the "visible range of cells" -lets say: E5...) as always, thanks in advance, Mark |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
freeze pane command usage (clarified)
Hi Mark,
Try this Application.Goto reference:=Range("b2"), Scroll:=True Range("D4").Select ActiveWindow.FreezePanes = True Range("E5").Select -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "mark kubicki" wrote in message ... just plain old stuck on this one... How would I go about freezing the view of my active window at D4, with B2 at the top left corner of the screen (first visible row, top row = 2, first visible column, left -most column = col B) ? clarification: i'm looking for a way to do this with code, knowing that the active cell might be anywhere on the sheet (although, after i do all of this "stuff", the active cell would be in the "visible range of cells" -lets say: E5...) as always, thanks in advance, Mark |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
freeze pane command usage (clarified)
Hi
maybe not exactly what you want but try sub foo() columns(1).hidden=true rows(1).hidden=true Range("D4").Select ActiveWindow.FreezePanes = True Range("E5").Select end sub -- Regards Frank Kabel Frankfurt, Germany mark kubicki wrote: just plain old stuck on this one... How would I go about freezing the view of my active window at D4, with B2 at the top left corner of the screen (first visible row, top row = 2, first visible column, left -most column = col B) ? clarification: i'm looking for a way to do this with code, knowing that the active cell might be anywhere on the sheet (although, after i do all of this "stuff", the active cell would be in the "visible range of cells" -lets say: E5...) as always, thanks in advance, Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Freeze pane command on 2007 not highlighted | Excel Discussion (Misc queries) | |||
freeze pane: freeze from two worksheets? | Excel Discussion (Misc queries) | |||
freeze pane for more than one row anyone??? | Excel Discussion (Misc queries) | |||
Freeze Pane command freezes more cells than I selected. | Excel Worksheet Functions | |||
freeze pane command usage | Excel Programming |