Posted to microsoft.public.excel.programming

qwerty[_2_] qwerty[_2_] is offline

external usenet poster

Posts: 8

Setting column width if #### appears in column

If a column is not wide enough for the displayed number, it shows # signs.
In VBA is there a way to detect which cells in which columns have that ###
so I can use column autofit to set to the width needed?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Setting column width to specific row in Excel doc ??? Thanks!	Setting column width to specific row	Excel Discussion (Misc queries)	2	July 8th 09 02:07 AM
setting column width	James	Excel Discussion (Misc queries)	1	July 11th 08 12:02 AM
Setting column width in a table	Box815	Excel Discussion (Misc queries)	4	October 11th 06 06:34 AM
Setting the Width of a column	Nirmal Singh	Excel Programming	5	May 27th 05 05:16 PM
Setting column width	Brad E.[_2_]	Excel Programming	2	January 21st 05 05:26 PM

All times are GMT +1. The time now is 05:25 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us