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" wrote in message
...
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)