How to AutoFit columns to data using VBA. 🤯

Follow @exceldictionary for more tips and tricks. To learn all of Excel’s shortcuts and productivity hacks like this, check out my new course, ebooks, merch, and more linked below. 👇🏼

You can also just double click the header and will do it quickly too!

Please do not encourage the use of VBA. It’s 2023.

Thanks for sharing on most awaited post on VBA...

Digging your Excel content! 💪 Unlock VBA Excel potential in my YouTube:

Thanks 🙏

Oh wow

Only works on XLSB or XLSM workbooks? Or can it work on XLSX?

I tried this…but it seems to have a bug…you can not use ctrl z(undo) command

What song is that in the background though😅