Positioning
 

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

Positioning
 

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

Positioning
 

Roger,
Something like:
range("D1:N1").select
activewindow.zoom=true

NickHK

"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

Positioning
 

Nick, glad you arrived with the correct solution ...

Bill

"NickHK" wrote in message
...
Roger,
Something like:
range("D1:N1").select
activewindow.zoom=true

NickHK

"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

Positioning
 

Nick thanks for you solution which works well if I want to shrink my file to
show the parameters I mentioned. This could be useful in the future. My
appologies in not making my request clearer. My sheet is already formatted
so that the area D1 to N1 shows if D1 is in the upper left hand corner of my
screen. In Excel 5 I used 'Application.GoTo Reference:=Range("G3")' to
solve the problem but it doesn't work in my 2002. I hope this is much
clearer.

Many thanks again,
Roger



"William Benson" wrote in message
...
Nick, glad you arrived with the correct solution ...

Bill

"NickHK" wrote in message
...
Roger,
Something like:
range("D1:N1").select
activewindow.zoom=true

NickHK

"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