Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 96
Default autofit with wrap

is it possible to program via vba a means to autofit column that has a
wrapped cell in the header where the column width is based on the longest
contiguous string of characters within the cell?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,565
Default autofit with wrap

Autofit will find the best fit for the text that is entered. It is not
based the length of a string.


"joemeshuggah" wrote in message
...
is it possible to program via vba a means to autofit column that has a
wrapped cell in the header where the column width is based on the longest
contiguous string of characters within the cell?



Reply
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
Are there limits autofit row height when the cell is set to wrap t Pat Excel Discussion (Misc queries) 3 March 25th 08 05:50 PM
Autofit and word wrap don't work? Jack Greb Excel Discussion (Misc queries) 12 January 15th 07 05:32 PM
Excel autofit and word wrap Janine Excel Programming 1 October 20th 05 05:46 PM
Can you get a Merged Cell with Text Wrap to Autofit? jennie Excel Programming 0 September 24th 04 12:36 PM
Can you get a Merged Cell with Text Wrap to Autofit? jennie Excel Programming 3 September 24th 04 12:12 PM


All times are GMT +1. The time now is 06:37 PM.

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

About Us

"It's about Microsoft Excel"