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.
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.
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks