Visual Basic in Excel, Resize the Cell automatically

P

Pam

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code character limit with Resize or Transpose or cell? 8
Visual Basic Excel How do I determine if cell is numeric or text 1
Named cells in an array to a column and to a row 3
resize rows and column 2
Automatically resize a picture to a cell 2
Range.Resize from Visual Basic in Windows to Excel 2
excel 2
resizing listbox columns in excel userform 1

Top