Run Error 13

[Jonsson]

Hi Jim

Actually, I have formulas in "A" getting names from another sheet
=Name(A1) and so on.
If the formula doesnt return any value from Sheet"Name" there is no
problem. The error occours only when formula returns a value(in this
case a name).

Sorry for not mentioned this in my previous post!

Hope that gave a little bit better angle to my problem.

//Thomas

 

[Jim Rech]

Ah! Well if the formula can return a number or a string that causes Excel
97 a problem since an error occurs when you compare a string to a number
(zero in this case).

One thing you could do I think:

Rows(i).EntireRow.Hidden = (CStr(Range("A" & i).Value) = "0")


This always makes it a string to string comparison.


--
Jim Rech
Excel MVP
|
| Hi Jim
|
| Actually, I have formulas in "A" getting names from another sheet
| =Name(A1) and so on.
| If the formula doesnt return any value from Sheet"Name" there is no
| problem. The error occours only when formula returns a value(in this
| case a name).
|
| Sorry for not mentioned this in my previous post!
|
| Hope that gave a little bit better angle to my problem.
|
| //Thomas
|
|
| --
| Jonsson
| ------------------------------------------------------------------------
| Jonsson's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=5472
| View this thread: http://www.excelforum.com/showthread.php?threadid=275299
|