Query in Macro

Closed

cool - Sep 10, 2009 at 02:10 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Sep 13, 2009 at 04:11 AM

Hello,

i have an excel file. contains 2000 rows and 6 columns. if Column "A" contains "1" and Column "B" contains "sweet", the entire row has to delete.

For example, almost 100 rows may be like that. But i wanted to delete all 100 rows.

Please any help on this.

Query in Macro
Spell number in excel without macro - Guide
Macros in excel download free - Download - Spreadsheets
Excel macro to create new sheet based on value in cells - Guide
Run macro on opening workbook - Guide
How to avoid duplicate records in sql select query - Guide

1 response

Answer 1 / 1

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Sep 13, 2009 at 04:11 AM

Hi
Just Filter and delete

Similar discussions

Automatically Run Macro from a calculated cell value change

Code for macro that conditionally inserts rows

How to convert number into text in Excel

Execute Macro On Calculated Cell change

Similar discussions

Subscribe To Our Newsletter!