I am looping through a column and if the cells contain either of the following:

"#value!"
"#DIV/0!"
"#REF!"

how do i do that?

dstiefe:

if your data in range("A1:A6")

try,

Dim rng As Range
For Each rng In Range("A1:A6")
If Not IsError(rng) Then
MsgBox rng.Value
Else
MsgBox "Is Error Range" & rng.Text
End If
Next rng

--
天行å�¥ï¼Œå�›å*�以自強ä¸�æ�¯
地勢å�¤ï¼Œå�›å*�以厚德載物

http://www.vba.com.tw/plog/


"dstiefe" wrote:

I am looping through a column and if the cells contain either of the following:

"#value!"
"#DIV/0!"
"#REF!"

how do i do that?