hi:

I have a wb with 150 ws. some cell in some ws have an #N/A and ther
is no formula in the cell. how can I replace the # with a blank o
just plainly turn that cell value to zero. I have way to many ws to d
it by hand.


any help is greatly appreciated

--
halem
-----------------------------------------------------------------------
halem2's Profile: http://www.excelforum.com/member.php...nfo&userid=993
View this thread: http://www.excelforum.com/showthread.php?threadid=55749