See
http://www.cpearson.com/Excel/zoom.htm#center for some example
VBA code to center a range of cells in the active window.
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
On Tue, 18 Aug 2009 11:45:48 -0700 (PDT), dgold82 <(E-Mail Removed)>
wrote:
>I would like to center my displayed columns in the middle of my window
>instead of the current position on the left. Most of the columns on my
>worksheets are either hidden or deleted which leaves a couple inches
>to the right of the worksheet empty on my screen.
>
>Is there a way to center the displayed columns without expanding them
>or manipulating the worksheet? Perhaps with VBA?
>
>It's just a little thing, but it's like looking at a website that is
>not centered on your screen when IE is maximized. It works fine, just
>is a little annoying. Thanks!