How do you autoformat an excel database to automatically make both the cell length, and width the exact size it needs to be to display the full name,numbers, etc of your data?
For instance in the attached file many of the variable names are cut off, for instance "state_abbreviation" is not fully visible.
edit: This may be the wrong forum, please remove if so.
Here's a small macro you can run as needed for the active worksheet.
Copy it to a standard module, then run as needed.
Please Login or Register to view this content.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks