Loop through a range to hide rows

[Utah_Jackson]

I want to loop through a range. If any data exists on the row of the range from Column C over to the last column in use, I want to hide the row.

I have questions about null and zero values in the cells. Cells can have either in a row of data. I am hiding zero values but I am assigning a zero value via a function for some cells.

Using code from a post dealing with a similar problem, this is what I came up with.

(Sorry if I was supposed to put this in tags. I didn't see the tags for the code on this forum.)

Please Login or Register  to view this content.

Please offer suggestions for my code.

Thanks in advance.

[Leith Ross]

Hello Utah_Jackson,

To make your posts easier to read and preserve your formatting, please wrap your code. I did it for you this time. Here is how you can do it next time.

How to wrap your Code
On the Message window Toolbar you will see the # icon. This will automatically wrap the text you selected with the proper CODE tags to create a Code Window in your post. You can do this manually by placing the tag [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end.

As a new member please take so time to familiarize yourself with the Do's and Don'ts here in the Forum, just click on the
link below...

Forum Rules

Sincerely,
Leith Ross