When I open my Excel at one PC, there are 9 columns within the sheet (A to I). at another PC, my sheet shows 8 columns (A to H). Thus, the alignment of my report is messed up. Is there a way to set a fixed number of columns in an Excel sheet?
Printable View
When I open my Excel at one PC, there are 9 columns within the sheet (A to I). at another PC, my sheet shows 8 columns (A to H). Thus, the alignment of my report is messed up. Is there a way to set a fixed number of columns in an Excel sheet?
No, it all depends on screen resolution. E.g. on my 30 inch flat panel I can see 28 rows (A to AB)http://www.vbforums.com/images/ieimages/2006/03/1.gif
You can set the View Zoom % or hide columns or both. Does this help?Code:ActiveWindow.Zoom = 50 'View Zoom 50%
Columns("J:IV").EntireColumn.Hidden = True