Visual Basic in Excel, Resize the Cell automatically

[Pam]

How do I automatically resize a cell in Visual Basic depending on the amount
of text I enter?

 

[Mike H]

Pam,

It depends on what you want to do. Like this

Range("A1").Value = "antidisestablishmentarianism"
With Range("A1")
.WrapText = True
End With

or like this

Range("A1").Value = "antidisestablishmentarianism"
Columns("A:A").EntireColumn.AutoFit

Mike

 

[Pam]

Perfect. The autofit works like a charm. THANK YOU!!