How to select a worksheet and delete the rows that are 0 or empty on column 3(C)

**lee478** · 05-26-2013, 10:06 PM

I am using sheet 1 and 2
I have extracted some data from sheet1 to sheet2
name of the sheet2 is BP
I want to write a macro that selects the worksheet "BP" and checks if column 3 or C in BP is empty or 0,If they are 0 or empty then delete the entire row.

any help would be appreciated!

Thanks,

**Trebor76** · 05-26-2013, 10:37 PM

Hi lee478,

Though I'm surprised you couldn't find any threads to help you on this popular topic, try this (though initially on a copy of your data as the results cannot be undone if they're not as expected):

Please Login or Register  to view this content.

Regards,

Robert

**Ed_Collins** · 05-26-2013, 10:44 PM

Unless you have one very large spreadsheet, most of column 3 will be empty. (All of the tens of thousands of unused rows.)

This code looks for data in column 1, and if THAT row has data in it, and there is nothing in column 3 (or 0), it will delete the row.

It will loop until it sees no more data in column 1, in which case it terminates.

Please Login or Register  to view this content.

How to select a worksheet and delete the rows that are 0 or empty on column 3(C)

LinkBack

Thread Tools

Rate This Thread

Display

How to select a worksheet and delete the rows that are 0 or empty on column 3(C)

Re: How to select a worksheet and delete the rows that are 0 or empty on column 3(C)

Re: How to select a worksheet and delete the rows that are 0 or empty on column 3(C)

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions