+ Reply to Thread
Results 1 to 16 of 16

looping in filtered range by rows

Hybrid View

HarryKlein looping in filtered range by ... 06-16-2016, 07:23 AM
AB33 Re: looping in filtered range... 06-16-2016, 08:02 AM
HarryKlein Re: looping in filtered range... 06-16-2016, 08:09 AM
AB33 Re: looping in filtered range... 06-16-2016, 08:14 AM
Norie Re: looping in filtered range... 06-16-2016, 08:19 AM
HarryKlein Re: looping in filtered range... 06-16-2016, 08:30 AM
Norie Re: looping in filtered range... 06-16-2016, 08:32 AM
HarryKlein Re: looping in filtered range... 06-16-2016, 08:35 AM
Norie Re: looping in filtered range... 06-16-2016, 08:39 AM
HarryKlein Re: looping in filtered range... 06-16-2016, 08:53 AM
AB33 Re: looping in filtered range... 06-16-2016, 08:47 AM
Norie Re: looping in filtered range... 06-16-2016, 08:51 AM
Norie Re: looping in filtered range... 06-16-2016, 09:03 AM
HarryKlein Re: looping in filtered range... 06-16-2016, 09:10 AM
Norie Re: looping in filtered range... 06-16-2016, 09:14 AM
HarryKlein Re: looping in filtered range... 06-16-2016, 09:19 AM
  1. #1
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: looping in filtered range by rows

    ar and rw are Ranges.

    The outer loop is looping through all the visible areas in the range "$A$1:$A" & lrSource, ie all the visible areas in column A.

    The inner loop is looping through all the rows in each of those areas.
    If posting code please use code tags, see here.

  2. #2
    Forum Contributor
    Join Date
    05-10-2011
    Location
    Budapest, Hungary
    MS-Off Ver
    Excel 2016
    Posts
    187

    Re: looping in filtered range by rows

    Sorry again, I mistyped the source.
    it is not only for column A, but "A:F", let's say. In this case how do I reference a cell within a row?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Issue with Looping Filtered Range of Visible Cells
    By Vinod Krishna.C in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-22-2015, 06:52 PM
  2. [SOLVED] Count of visible rows in a filtered range
    By brucemc777 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-16-2014, 01:17 PM
  3. Count rows of a filtered range
    By newbi004 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-29-2013, 06:30 AM
  4. [SOLVED] Looping the rows of an Array into a one range of rows repeatedly
    By Romulo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-25-2013, 10:54 AM
  5. [SOLVED] Copy first 4 rows of filtered range
    By Charles in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-22-2012, 03:02 PM
  6. Looping through rows in range AND comparing range cells
    By Damask in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-16-2006, 10:30 PM
  7. Define a range containing the first 10 rows of a filtered list
    By Marco in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-07-2005, 09:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1