Hi, Richard.  I think I've got a good one for you and hope that you'll be able to answer it in the forum.

I've got an Excel 2010 spreadsheet that has 13 columns.  I want to delete those rows and only those rows where the cell in either Col A or Col M are blank using  VBA.  I've tried recording a macro, but the macro specifies a row number to begin the delete after I've filtered to show only the rows with blanks.

I think an IF statement or a WHERE clause in an IF statement is the solution to my problem, but I'm only familiar enough with VBA to really mess things up royally.

Please help.  Thanks.

Michelle.

---

Reply from Richard Rost:

Yes, you'll need a VBA macro with a loop to handle this. I'm sure I could figure it out, but to be honest my Excel VBA is a bit rusty, so I can't just spout it off the top of my head (like I can with Access VBA). I don't program in Excel that much because (in my opinion) if something like this needs to be programmed, I'd do it in Access. I'm sure you could find the code to loop through rows with a Google search. If you can't and you really need a solution, submit it via my TechHelp page, and I'll have one of my guys write something up for you.