Delete blank rows

**Frankf** · 10-13-2009, 12:41 PM

I'm new to vba, and appreciate any help.
I'm trying to clean up several long worksheets by removing rows that don't contain a visable number or letter. I want to remove all rows that only contain either empty cells, formulas that evaluate to a empty text string (""), cells that contain error values, or cells that contain zeros, or any combination of the previous. I've stumbled onto the following, but it does not work.
Am I on the right track? Can anyone help modify this or offer a better solution? Thanks in advance.

Please Login or Register  to view this content.

**royUK** · 10-13-2009, 12:44 PM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

I will add them this time

**royUK** · 10-13-2009, 12:57 PM

This will remove all entirely blank rows

Please Login or Register  to view this content.

**royUK** · 10-13-2009, 01:10 PM

This should remove all rows with formulas resulting in zeros as well

Please Login or Register  to view this content.

**Frankf** · 10-13-2009, 02:07 PM

Thanks for the speedy reply.

Your macro does remove rows containing only blank cells, but does not remove rows with cells that contain a empty text string (""), or cells with a zero (0). I would like to remove those rows as well. Many rows of my worksheet are populated with cells that evaluate to either a "" or 0 if certian conditions are not met. I don't need those rows unless the formulas in the cells evaluate to either a positive number or visable text.

Thanks again for your help.

Frank

**royUK** · 10-13-2009, 02:23 PM

The second code should remove rows where all cells containing formulas return 0, does this work

Please Login or Register  to view this content.

**Frankf** · 10-13-2009, 03:05 PM

Thanks again.
Since some of the rows might contain blank cells, zeros, and/or blank text strings, I just modified your code to add all the conditions up and check to see if that added up to the number of columns in the range. It works perfectly. Thanks for the help.