omnipotentmero
New Member
- Joined
- Feb 16, 2012
- Messages
- 10
Hey all, I am looking for a way to automate my worksheet formatting, but I don't know enough about excel's VBA macros to write one myself. What I am looking to do is to autofit all column widths on a given worksheet, but to limit the maximum size to 50.
I often deal with 30+ columns that have a mix of relatively narrow data (date, times, IP address...) and wide data (long URLS, or block of text). I want to be able to shrink the narrow fields to their most efficient use of space, truncate everything else so it does not visually take up the entire screen.
Thanks in advance for your help.
I often deal with 30+ columns that have a mix of relatively narrow data (date, times, IP address...) and wide data (long URLS, or block of text). I want to be able to shrink the narrow fields to their most efficient use of space, truncate everything else so it does not visually take up the entire screen.
Thanks in advance for your help.