only select visible cells during loop

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


    Code
    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!