Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Linking to Visual Basic for Applications Help Files | Excel Discussion (Misc queries) | |||
changing the visual basic in office 2003 to visual studio net | Excel Discussion (Misc queries) | |||
What is the column width associated with cell borders? | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |