Another way:

Option Explicit
Sub testme()
Dim wks As Worksheet
For Each wks In ActiveWorkbook.Worksheets
wks.Cells.Replace What:="#n/a", Replacement:="", _
LookAt:=xlWhole, SearchOrder:=xlByRows, MatchCase:=False
Next wks
End Sub

Replacement:=""
could be
Replacement:="0"

if you wanted 0's.


halem2 wrote:

hi:

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

any help is greatly appreciated.

--
halem2
------------------------------------------------------------------------
halem2's Profile: http://www.excelforum.com/member.php...fo&userid=9930
View this thread: http://www.excelforum.com/showthread...hreadid=557492

--

Dave Peterson