LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Auto setting column widths accross a whole workbook


I was trying to write a macro to select all columns on all sheets in
the workbook and force the columns to fit to the data. However, even
using a tip here to select all the sheets, I could only get it to apply
automatic widths to the current sheet.

Is it possible to write a macro to do this?

Any help apreciated. Excel 2003.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
auto adjust column widths and row height DebC Excel Discussion (Misc queries) 1 November 24th 09 03:17 PM
Setting column widths the same on multiple worksheets John Excel Discussion (Misc queries) 2 April 19th 08 04:00 PM
Setting column widths when mapping out a field trial. Candys Kisses Excel Worksheet Functions 1 August 21st 07 12:12 AM
How do I share a workbook accross the internet? ryan Excel Discussion (Misc queries) 0 January 7th 06 05:32 PM
Share workbook accross FTP steven knight Excel Programming 0 September 9th 04 10:52 AM


All times are GMT +1. The time now is 11:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"