Hi All,
Just was wondering what tips folks have for AutoFitting columns dynamically. I have a few situations in this project that it'd be great if I can write a few functions to handle the formatting, but I'm stuck when it comes to good autofit solutions for the following:
1. Wrapped Text : Any thoughts on AutoFitting to the longest "Phrase"? I've tried split/search " " as options but this doesn't really identify the longest phrase per se, and more captures the longest word. I have some phrases with a chr(10) between phrases but others that don't
2. Autofit for numeric values and timing: I have a function that I added an autofit after the number formatting, but because I have disbled calcs the value in question isn't populated yet so I cannot really use this because it's autofitting to a zero value.
** Thanks for any/all your thoughts
Bookmarks