Display col width in a cell
 

Hi All
I would like to set a formula in each of the relevant cells in Row 1 to
display the column width (30 of them of different widths).
Any ideas would help. Rgds KZ

Display col width in a cell
 

Kieranz, try this,

Public Function CW(C As Range)
'Will show column width
'use like this = CW(A1)
Application.Volatile
CW = C.ColumnWidth
End Function

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Kieranz" wrote in message
oups.com...
Hi All
I would like to set a formula in each of the relevant cells in Row 1 to
display the column width (30 of them of different widths).
Any ideas would help. Rgds KZ

Display col width in a cell
 

Hi All
I got it, from UG. In each cell in the first row put =CELL("width",A1)
and copy across.
Thks.
Rgds
KZ
Kieranz wrote:
Hi All
I would like to set a formula in each of the relevant cells in Row 1 to
display the column width (30 of them of different widths).
Any ideas would help. Rgds KZ

Display col width in a cell
 

Hi Paul
Many thks, works perfect. My suggest doesn't give the decimals. it
rounds up.
Rgds
KZ

Kieranz wrote:
Hi All
I got it, from UG. In each cell in the first row put =CELL("width",A1)
and copy across.
Thks.
Rgds
KZ
Kieranz wrote:
Hi All
I would like to set a formula in each of the relevant cells in Row 1 to
display the column width (30 of them of different widths).
Any ideas would help. Rgds KZ