Excel 2007 : Compare cell values and Insert Row

[TechHelp]

I need help creating a macro that will automatically insert a row if the value in cell AA12 is greater than the value in cell AD12. This must be done down the entire worksheet by checking those two columns (AA and AD). I believe I need to include a IF statement in my insert row macro. Please help.

[Dennis7849]

Please Login or Register  to view this content.

[TechHelp]

Thank you for the quick reply. However, I'm receiving a run time error based on method "Range". The values start in row 12. Should I start the macro with these cells? There are also blank rows in the worksheet that the macro must skip.