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

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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

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

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