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" <roshin.majeed@gmail.com> wrote in message
news:1134485914.006298.27690@g47g2000cwa.googlegroups.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
>