i want to search ######## values in a sheet. if found then i have to
apply auto column fit. (## values have appeared coz the width of the
column is small than the value)

Vick
You don't need to search for ######. Just select all the columns with
data in them and do an autofit. Done. HTH Otto

"vicky" <(E-Mail Removed)> wrote in message
news:b587b3a4-1df1-4357-bf50-(E-Mail Removed)...
> i want to search ######## values in a sheet. if found then i have to
> apply auto column fit. (## values have appeared coz the width of the
> column is small than the value)

Check your other post.

vicky wrote:
>
> i want to search ######## values in a sheet. if found then i have to
> apply auto column fit. (## values have appeared coz the width of the
> column is small than the value)

--

Dave Peterson