Roger, are you talking about freezing the panes or something else? Freezing
with D on the left is no problem, but having N be on the right is untenable
because display settings, column widths, and hidden columns will impact ...
and of course, there is the fact that you could scroll past N at any time.

Here is a method for changing what area is viewable, from Norman Jones in
another forum: Search for the key word "scoll area"

http://www.pcreview.co.uk/forums/thread-1058259.php

Basicall, scroll to right so that Col D is on the left
Go into VB Editor (Alt-F11) and click on the sheet in Project explorer
In Properties Window, set Scroll Area property = $D:$N

Note: This will not help you hide O through whatever if the column widths
permit viewing of those columns, however.


Somehow I feel I may be missing what you are saying, if so I ask forgiveness
in advance and for more elucidation from you.

"Roger" wrote in message
...
I am interested in positioning a sheet so that D1 is on the left edge
showing and N1 is on the right edge showing. It seems that my old Excel 5
macros for this have changed in Excel 2002.

Any suggestions would be greatfully appreciated,

Roger