Can I Improve This Code?

[AHFoddeR]

Hey guys,

I've made a macro that works perfectly, but I'd like to improve the code (for educational purposes).

I've got a macro that sets a filter to a value in a cell, then copies the range to a sheet with the same name as the filter. I've set up variables for each cell, but I want to loop through the copy rather than repeating it.

Instead of repeating the code and changing Group1 to Group2, how can I use a loop to do this?

Thanks,
Lucas

P.S Code below

Please Login or Register  to view this content.

[stnkynts]

It was challenging to tell what you were really trying to accomplish with all the "Selections" as it gives us no reference. Try this and let me know how close i got:

Please Login or Register  to view this content.

[AHFoddeR]

Hey stnkynts,

Great response mate. Although the code didn't quite work, I wasn't after a functioning bit of code anyway. What you demonstrated perfectly was the syntax of how to set the variables and loop through them. Now I can recreate my code with this technique. Not to mention can appropriate it for other uses!

Thanks! Thread marked as solved

Lucas