Auto ajusting cells in a workbook

[gmr4evr1]

Moderators - I wasn't sure where/how to post this so if it is in the wrong forum, please move it to the correct one, thank you.

Hopefully this is something that will help others out

I was trying to find a way to "auto adjust" cells, in a workbook, based on how much text was in the cell. All of the help I could find about this was to go through options/settings for a sheet. I needed it to work for the entire workbook as I have code that creates a new sheet and then emailed that sheet. This was done with the click of a button so there wasn't a way for me to go to the new sheet and change the settings. I thought all was lost until I FINALLY, after an exhaustive search, came across this code

Please Login or Register  to view this content.

Place it in the workbook section of VBA and it will adjust the cell length according to the amount of text that is in the cell. Keep in mind, the adjustment only happens after hitting enter, tab or clicking in another cell.

[FDibbins]

Thanks for this

I am going to move it to the Tips forum

[gmr4evr1]

You're welcome, and thank you for moving it to the correct forum as I didn't scroll down far enough to see the "Tips" forum...oops.