AutoFit Column Activity Doesn't Work

[mazlumkacar (mazlum kaçar)]

Hi all,

I am tyrying to use AutoFit Column Activity but my excel is still the same. Where am i doing wrong?

[tracydixon]

Have you tried selecting the full column before the autofit?

[fernando_zuluaga]

@balupad14

[balupad14 (Balamurugan)]

I saw the image. Use the Autofit Column after the excel application scope. Don’t use inside.

Regards
Balamurugan.S

[fernando_zuluaga]

i just mentioned you to help the guy xd. Regards dude! appreciate you

[Snehal14Kapse (Snehal)]

Use Invoke VBA Activity Inside Excel Application scope. Inside this provide the Text file path & Macro name inside Properties panel. And Paste the below macro code inside Text file.

Sub AutoFitColumns()

Dim sht As Worksheet

'AutoFit Every Worksheet Column in a Workbook
For Each sht In ThisWorkbook.Worksheets
sht.Cells.EntireColumn.AutoFit
Next sht

End Sub