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