Modify VBA code to hide blanks rows

Hi,

I have a great code that I want to modify. The code hides rows if the sum of the row is smaller or larger than zero. But I want to modify the code so it hides the rows only if it is blank. So a row with a string of text in it will not get hidden.

Please Login or Register  to view this content.

I am making an excel file for come co-workers and it needs to be as clean and simple as possible. One way to remove unused rows would be to set a macro to a button. Clicking this button would hide all unused rows. A filter would not work as well. I only need to figure out how to change

If RowRangeValue <> 0 Then

to search for word and numbers.

hi, Ranew, I've amended my last post, try to change that line

watersev, a good step forward

The code hides blank rows! Unfortunately I have alot of rows containing formulas, but returns blanks. I need to hide them aswell.

I found this;

Please Login or Register  to view this content.

I don't know if it is of any help...