freeze pane command usage

  • Thread starter Thread starter mark kubicki
  • Start date Start date
M

mark kubicki

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) ?

as always, thanks in advance,
Mark
 
Hi
one way:
- hide column A and row 1
- move the cursor to D4 an goto 'Window - Freeze Pane'
 
usually i just move to A1, then scroll down and over to take the rows/
columns out of view, then select D4 and FreezePane

i'm looking for a way to do this with code, knowing that the active cell
might be anywhere on the sheet (after i do all of this "stuff", the active
cell would be in the "visible range of cells" -lets say: E5...)
 
Back
Top