Excel ISERROR function
 

I have 8,000 line of data to apply function to, it works but the data element
I am comparing has to be rekeyed into cell to make function work properly.

Excel ISERROR function
 

Mark

Not sure what your problem is.

Do you have the ISERROR function already in your formulas but doesn't work
until you F2ENTER

This would indicate that the cells are formatted as text.

Format to General then select all and EditReplace

What: =

With: =

Replace all. This forces Excel to treat as a formula.

OR you need the ISERROR added to each formula?

Sub ErrorTrapAdd()
Dim myStr As String
Dim cel As Range
For Each cel In Selection
If cel.HasFormula = True Then
If Not cel.Formula Like "=IF(ISERROR*" Then
myStr = Right(cel.Formula, Len(cel.Formula) - 1)
cel.Value = "=IF(ISERROR(" & myStr & "),""""," & myStr & ")"
End If
End If
Next
End Sub


Gord Dibben Excel MVP

On Mon, 12 Dec 2005 13:09:05 -0800, "MarkD"
wrote:

I have 8,000 line of data to apply function to, it works but the data element
I am comparing has to be rekeyed into cell to make function work properly.