Try

? LIKE("#*", oSheet.Cells(2,6).Text)

>
>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.
>