Hi Guys,

When a figure does not fit in a column, Excel displays it in form of hashes (something like ######). When Automating, is there a way to test for a cell of this nature ? The AUTOFIT function can be used to display everything but in some cases AUTOFIT exagerates the width especially if a long title exists.

Please help


Fred Matano Kotte