Adjust Cell Width in Visual Basic
 

I am trying to adjust the width of an individual cell (not the entire column)
in Excel using visual basic. I have been able to do it for the whole column
(below), but want to know if it is possible to do it for just one cell.

Sub FormatRange()
Workbooks("book1").Worksheets("Sheet1").Columns("A ").ColumnWidth = 5.1
End Sub

Adjust Cell Width in Visual Basic
 

when you find out how to widen one cell. without center across or merge
cells, pls let us all know.

--
Don Guillett
SalesAid Software

"j" wrote in message
...
I am trying to adjust the width of an individual cell (not the entire
column)
in Excel using visual basic. I have been able to do it for the whole
column
(below), but want to know if it is possible to do it for just one cell.

Sub FormatRange()
Workbooks("book1").Worksheets("Sheet1").Columns("A ").ColumnWidth = 5.1
End Sub

Adjust Cell Width in Visual Basic
 

Can you do it manually?

NO.

A cell is part of a column and the width is a property of the column.


Gord Dibben MS Excel MVP

On Wed, 5 Jul 2006 08:32:01 -0700, j wrote:

I am trying to adjust the width of an individual cell (not the entire column)
in Excel using visual basic. I have been able to do it for the whole column
(below), but want to know if it is possible to do it for just one cell.

Sub FormatRange()
Workbooks("book1").Worksheets("Sheet1").Columns("A ").ColumnWidth = 5.1
End Sub