Hi Everyone,
I was looking for a solution to add only visible cells to an array and I was able to find one that works.
While it seems simple, I am having trouble grasping the concept of why this solution works so well.
Particulary, I want to know why setting a range for Cell 1 and the same range for Cell 2 is able to isolate the desired range.Please Login or Register to view this content.
Why wouldn't one set the cell for cell1 to "C2" and the cell for cell2 to "C208"? I've noticed when I try to test this, the loop appears to never end...
Also, when I print the value of ys(0), ys(etc..), it seems to be all over the place, but the value of a(0), a(etc..) is always the desired visible cells in my list.
How does this work? What is the initial value of ys, and how does the loop end properly?
Thank you
Bookmarks