If(iserror(????)

[wisemank]

Scenario:

I have a row of cells that make up a time line (E44:BA44) Starting at E44 moving left to right, the days (formated as dates) on the timeline are a sequence using formulas pointing to the startdate with the appropriate incrementation.

Question:

If I have a blank begin date all the corrisponding sequence dates are in error. I can manually add an IF(iserror(),"",()) command to the formula, but my question is this.

Can I create a macro for the toolbar that could properly insert the IF(ISERROR...statement and replace the existing formula while maintaing the original formula existing in the cells?

See Example below:

Actual Equation for F44: (=E44+2)
Results:
E44 is : 8/01/2010
F44 results: 8/03/2010

If E44 is blank then the rest of my timeline string is in error. The timeline equations can be different increments depending on the requested overall length of time required. Other than manually attacking this is there and easy way to replace the existing formulas to include the error statement?

 

[MrKowz]

Try:

Public Sub addiserror()
Dim i As Long
For i = 5 To 53
    Cells(44, i).Formula = "=IF(ISERROR(" & Cells(44, i).Formula & "),""""," & Cells(44, 1).Formula & ")"
Next i
End Sub

I haven't tested it yet, so I'm concerned that it may add in an extra "=" every time it uses Cells(44,i).Formula. Be sure to back up your current formulas before you use it!

 

[wisemank]

Thanks. I'll Try it and see what goes....

Would be nice for MS to add buttons to insert these types of commands after the fact...