Trouble Running IF Statement while recording Macro

I'm trying to enter an IF statement while recording a macro, and normally this wouldn't be a problem. But with this particular IF statement, an error ("Unable to record in macro")comes up right after I push the "Enter" after writing in the statement. After I'm recording the Macro, I notice there is no IF statement in the actual VBA code.

Here's the IF statement:

=IF(AND(OR(D2="500 Account",D2="055 Account"),OR(LEFT(B2,2)="LT",B2="** Investment Intraco",B2="Fed Funds Purch Account",B2="Fed Funds Account")),1/0,IF(OR(D2="500 Account",D2="055 Account"),1,1/0))

Can anyone see why this particular IF statement would cause a problem while recording the macro?

Thanks in advance...

Originally Posted by tlafferty

protonLeah is correct about the divide by zero error, however I'm still able to record a macro which writes the formula in a VBA module. The user probably has an Excel session which has gone wonky and just needs to restart it.

I have already restarted my computer and it yields the same result. Also, I actually want it to show an error as part of the process. So the 1/0 is fine.

Any other ideas? thanks

I've attached a dummy workbook (titled Test Equation). I can't share the original file because of the information involved.

But below the yellow highlighted cell you will be able to see the equation.

A little background: The reason I want to make the cells an error is so that I can delete all rows which contain certain values. So, in the case of the dummy workbook, I would WANT to delete all rows which include "LT", "**", "Fed Funds Purch", "Fed Funds Term" in column B. OR, any other value in column D besides "YY" and "YY5" should warrent the row to be deleted.

I'm using errors so that I can EDIT-GO TO-SEPCIAL-ERRORS and then EDIT-DELETE-ENTIRE ROW.

Originally Posted by tlafferty

Try this code instead:

Please Login or Register  to view this content.

This will locate and delete any row matching the criteria you specified. The case selection refers to column numbers, so if you wanted to examine column C or E, add criteria to case 3 and 5.

Thanks for the code... I'm really new to VBA, so I have a couple questions.

- Can I record the macro, exluding this step, and then simply input this code into the recorded macro where I want it? If so, do I need to make any alterations prior to inserting this code?

- Why is "Case Is = 5" located after the other "Case Is" statements?

Thanks

Bump... Anyone got an answer to that last question?