Hello,
I'm new to the visual basic editor (I'm using Excel 2010) and need some help writing a macro. I have column I, which is the sum of columns A and B (first and last names of patrons), and I have used conditional formatting to identify all duplicates in column I with red text. I would now like a macro to find red text in column I and then delete the corresponding rows.
I've been looking around on the web for a while and have cobbled together this code stolen from other people's macros:
When I run it, I get the following error:
Run-time error '1004':
Application-defined or object-defined error
Excel doc is called "stupid mailing list.xlsm", sheet I want to run the macro on is called "voters".
Hopefully that's enough info for somebody to give me a hand!
Bookmarks