View Full Version : Solved: Cell Error ####
Emily
02-25-2007, 01:18 AM
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
02-25-2007, 02:43 AM
If InStr(1, ActiveCell.Text, "###", vbTextCompare) Then
MsgBox "oops!"
End If
Emily
02-25-2007, 03:09 AM
Thanks xld
Is there other method not apply ActiveCell.Text?
Bob Phillips
02-25-2007, 03:13 AM
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
02-25-2007, 03:14 AM
Why do you not want to use that approach?
Emily
02-25-2007, 03:36 AM
I want to confirm that ActiveCell.Text is the ONLY method. :beerchug:
Bob Phillips
02-25-2007, 03:43 AM
Well, it is the only way I know. Let's see if anyone knows another.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.