Thanks Chip! You know, I Googled around a bit before posting. I saw a
sample that used your technique, but I couldn't get that working...thus the
post.

Thanks to everyone who participated!
Ryan---



--
RyGuy


"Chip Pearson" wrote:


If Application.WorksheetFunction.IsNA(mycell) Then

Just for the record, another way is

If mycell.Value = CVErr(xlErrNA) Then
Debug.Print "N/A error"

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Thu, 22 Jan 2009 13:24:06 -0400, "Bernard Liengme"
wrote:

My guess: a cell my DISPLAY #N/A but it may STORE a formula such as
=IF(A10,A1, NA())
The trick is to have VBA know that you do not mean: does the cell have the
text "#N/A" ?
This user-defined function tell if mycell is displaying #N/A or not

Function trythis(mycell)
If Application.WorksheetFunction.IsNA(mycell) Then
trythis = "Has NA"
Else
trythis = "Not NA"
End If
End Function

best wishes