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
|