View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
j j is offline
external usenet poster
 
Posts: 128
Default 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