how do you insert into a excel cell the column width automaticall
This formula returns the column width of the cell it is in: =CELL("width")
It rounds to the nearest integer however. If you wanted something more
exact you'd have to use a macro. If you put this in a standard module:
Function ColWidth()
Application.Volatile
ColWidth = Application.ThisCell.ColumnWidth
End Function
Then you can enter =ColWidth() in a cell.
--
Jim
"Paul" wrote in message
...
| How do you insert into a excel cell automatically the column width?
|