#N/A (XL2K SR-1)

Topic

New Reply

I have a formula (=IF(ISNA(AC156),NA(),$AF$164)) in a cell that can return the #N/A error, which is fine. I want to programmatically check to see if that is what is in the cell. Activecell.Value won’t work as it is not a value. Can someone point me to the correct code to programmatically check for the #N/A? Thanx in Advance.

Dennis

Reply | Quote

Replies

Hi Dennis,
Try:
Activecell.text = “#N/A”
HTH

Reply | Quote

Worked like a charm!! Thanx so much.

Dennis

Reply | Quote

Worked like a charm!! Thanx so much.

Dennis

Reply | Quote

Hi Dennis,
Try:
Activecell.text = “#N/A”
HTH

Reply | Quote

If that formula is in A1, then you could use:

    If Range("A1").Text = "#N/A" Then

Reply | Quote

If that formula is in A1, then you could use:

    If Range("A1").Text = "#N/A" Then

Reply | Quote