Delete rows with specific words from an excel sheet with web data, generated using a macro

Hi, guys!

I have created a macro that imported huge data from a web site as a web query.

This sheet contains 12 colums x 12,000 rows.

From this sheet, I want to remove rows containing words "Red" or "Blue".

Please help me.

Problem is simpler than what I originally stated. It is like this.

I have created a macro that imported huge data from a web site as a web query.

This sheet contains 12 colums x 12,000 rows.

From this sheet, I want to remove rows containing words "Red" or "Blue", appearing in Column A (the first column in the sheet).

Please help me.