copy the content of the cell to an empty column. autofit that column. Get
the column width from that column. Clear/resize that column. Set the
column in question to that width.

--
Regards,
Tom Ogilvy

"RosH" wrote in message
ups.com...
Hi everyone,

Is there any way by which i be able to know the width of the contents
of a cell. I need to change column width of a column according to the
width of the contents. Autofit would work but according to the longest
content in the column. I need the column width to be set according to
the width of a specific cell content. Thank you in advance. BYE