AutoFit Column ("F")

[Livin404]

Greetings,

I'm confident this is so much easier than my last post which fortunately I was able to sort out myself.

I want to include a line in an existing Macro to auto fit a column where I have an existing Macro, so I don't have to create an extra one.

My current Macro is:

Sub Delete_Columns()
    Columns("G:I").EntireColumn.Delete
End Sub

I want to autofit Column F. I concatenated cells F through I leaving only Column F with text. Then I deleted Columns "G:I". Now I just need to extend the length of Column F.

Thank you so much!

 

[Peter_SSs]

I want to autofit Column F

Did you try recording a macro to do that?

 

[Livin404]

Did you try recording a macro to do that?

It was too easy, I just simply added, and it worked fine. Thank you

 Range("F1").EntireColumn.AutoFit

 

[Livin404]

Did you try recording a macro to do that?

Sorry about that. Spent a lot of time working on other parts in VBA, and didn't think it would be as straight forward. Your response made me try the obvious. Thank you,