| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Putting a value in specifc Excel cell from Visual Basic | Excel Programming | |||
| Can I run Visual Basic procedure using Excel Visual Basic editor? | Excel Programming | |||
| Range.Resize from Visual Basic in Windows to Excel | Excel Programming | |||
| Excel Cell Formating in Visual Basic 6.0 | Excel Programming | |||
| Visual Basic to reference value in Excel cell | Excel Programming | |||
Linear Mode
