skip hidden rows in loop

**secondrate** · 07-09-2010, 06:09 AM

Hi guys, i wrote a macro using a for loop which goes through all the rows of a specified column. How do you write a code such that if the current row is hidden, it will proceed to the next row?

Please Login or Register  to view this content.

produces an error.

**Wizz** · 07-09-2010, 06:22 AM

Hi Secondrate,

You should use something like:

Please Login or Register  to view this content.

If the row is hidden, it will omit all the code betwin If and End If.

Resume Next is used for error hanlding :

Please Login or Register  to view this content.

**secondrate** · 07-11-2010, 08:41 AM

thanks for the tip!

skip hidden rows in loop

LinkBack

Thread Tools

Rate This Thread

Display

skip hidden rows in loop

Re: "Continue" version (of C++) in VBA?

Re: skip hidden rows in loop

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions