Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Expand All Column Widths
Is there a way programmatically to go through a Worksheet object and
autoexpand all of the column widths out so I don't see any #######'s when I view the end result? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Expand All Column Widths
What about a none programming solution,
Select all cells double-click on any boundary between the column letters http://www.mvps.org/dmcritchie/excel/fillhand.htm#mouse If you want a macro, you can record one Some errors of ####### will expand to fit what you got. See # in your Excel Help (well I guess you had to be on something before Excel 2002, hmmmmpf!, bad karma) Okay a negative number formatted as a date is one of them --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "BlockNinja" wrote in message ... Is there a way programmatically to go through a Worksheet object and autoexpand all of the column widths out so I don't see any #######'s when I view the end result? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Different widths for each column in a 100% stacked column chart | Charts and Charting in Excel | |||
Different column widths? | Setting up and Configuration of Excel | |||
Different column widths | Excel Worksheet Functions | |||
Column Widths help ? | Excel Programming | |||
Column Widths help ? | Excel Programming |