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'

--
Regards
Frank Kabel
Frankfurt, Germany
"mark kubicki" schrieb im Newsbeitrag
...
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

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


"Frank Kabel" wrote in message
...
Hi
one way:
- hide column A and row 1
- move the cursor to D4 an goto 'Window - Freeze Pane'

--
Regards
Frank Kabel
Frankfurt, Germany
"mark kubicki" schrieb im Newsbeitrag
...
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