only select visible cells during loop

  • I have a simple macro that loops through a range of cells using the following;

    Dim row
    For row = 1 to 100
    next row

    My question is how can I modify that statement to exclude rows that are hidden? I have looked at many threads but I must not be using the right terms because I can't find anything that addresses this.

    Many thanks in advance!

  • Re: only select visible cells during loop

    Please ignore this post. The suggested answers contained the answer! (for some reason they didn't appear when I tried the keywords)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!