Loops

[TheGainmaker]

Hi All,
I am pretty new to VBA and wondered if someone could give me a hand.
I am trying to deliminate a bunch rows using that have been auto filtered.
When I tried to select the whole column, I lost some critical information so I think I need a loop statement that starts at the first row that meets the criteria, like row 12, deliminates the data, then moves to the next one, which may be row 31,

Thanks to the community in advance for the help!

[JBeaucaire]

Lost information in what way? An autofiltered list is a great way to reduce rows to evaluate, but you need to be specific about what you're doing.

1) I've applied an autofilter to column G
2) My data starts in row 2 and goes down a random number of rows, it changes
3) There is nothing in column G below my data set

4) After filtering column G manually, I would like to evaluate all the remaining visible rows by:

a - doing this
b - then doing this
c - and the result I'd like is....

You get the idea.


In VBA, you can set a "RNG" variable for all the currently visible rows, then loop through the cells in the range you set:

Please Login or Register  to view this content.