Delete rows in a selection?

**scottkrise05** · 07-07-2010, 11:19 PM

I'm new to the forum and I have used a lot of great ideas from a lot of the great users on the forum. I know that somone will be able to help me out on this as I have seen alot of what I call complex macros in the forum. So here is my question.

How do I delete rows with a cell value of "0" in a selection I have selected in Excel? I have tried this macro which is I have tweaked from a previous macro that was used to hide "0" in a selection, but it will only delete half of the "0" that I have selected. Here is the macro, can someone please help?

Thank you!!!

Please Login or Register  to view this content.

**scottkrise05** · 07-08-2010, 08:49 PM

I was able to rewrite a macro that will allow me to delete rows within a selection with "0" (zeroes) in it. I had a lot of help from other posts out there that gave me a ideas of how I could make this work. I'm sure that if anyone wanted to do this with a value other than "0" (zero) then you could replace the "0" with what ever text you want.

Next time I will remember to use the code tags on my post as I did not do on my orginal post. Thank you so much everyone!

Here is the code...

Please Login or Register  to view this content.

Delete rows in a selection?

LinkBack

Thread Tools

Rate This Thread

Display

Delete rows in a selection?

Re: Delete rows in a selection?

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions