Solved: Cell Error ####

[Emily]

Excel cell contains a number or calculation result that is too wide to display will produce error message #### in cell.

#### seems not error value


How to use VBA to check active cell shows #### ?

InStr(ActiveCell.Text, "#") is one way

Thanks

[Bob Phillips]

If InStr(1, ActiveCell.Text, "###", vbTextCompare) Then
MsgBox "oops!"
End If

[Emily]

Thanks xld

Is there other method not apply ActiveCell.Text?

[Bob Phillips]

There is other than activecell, you can refer directly to a cell reference, but I don't see how you can use anything other than the Text property. That 'error' is not a property of the cell, it is just a presentational aspect, and Text is the only property that I can think of that addresses a cell's presentation.

[Bob Phillips]

Why do you not want to use that approach?

[Emily]

I want to confirm that ActiveCell.Text is the ONLY method. :beerchug:

[Bob Phillips]

Well, it is the only way I know. Let's see if anyone knows another.