How to Autofit Columns in Microsoft Excel VBA | JCC Tangi

[@tagliente862]

Cells.EntireColumn.Autofit Cells.entireRow.Autofit

[@SLOBOZHANSHYNA]

Thank you very much, I'll try do like this in Libre Office Calc.

[@muhammadanas808]

brother....v good and clear...slow method to teach...great !!!!make more videos like that

[@jcctangi]

appreciat your encouragment

[@gidionmibaluro7085]

good idea ..........thank you

[@ManishKumar-wj6ot]

Thank you

[@Samsheikh009]

Thank You 😊

[@jcctangi]

welcome

[@ParkerPeter-ve5nu]

Hi~I'm wondering if the VBA code avoids the undo/redo function Is there any way to fix it? THX

[@Dlblsn]

If you type iPad iPhone Apple Watch in a column, the column widens. But if you apply a filter and iPad ticks the column does not shrink because it keeps the width for the word Apple Watch even if hidden.

[@ez3736]

What if I want it for the all excel I should do it sheet by sheet ? 😅

[@jcctangi]

repeat sheet by sheet

[@ez3736]

@jcctangi there's no way for all the excel ?

[@kalimuthum5872]

But the undo option is not working

[@BrownDusky]

it doesn't work for codes

[@anandgadde3642]

Not working