Visual Basic in Excel, Resize the Cell automatically
 

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

Visual Basic in Excel, Resize the Cell automatically
 

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" wrote:

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

Visual Basic in Excel, Resize the Cell automatically
 

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

"Mike H" wrote:

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" wrote:

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