Newbie Question: Repeat Operations on Named Ranges - Can I loop this macro for efficiency?

Hi all -

I'm new to the Forum (This is my first post) and a relative beginner to programming in VBA. Please forgive the way I posted my code below, I couldn't figure out how to get it properly indented into the scrolling box (advice on that is also welcome!)

I have a procedure that repeats 18 times based on a series of named ranges, and am trying to figure out how to loop the procedure to work for each range name in sequence and then increment, rather than paste the procedure 18 times (Which is what I have now).

All of the resources I have consulted seem to give examples of looping through either a single range or all ranges on a worksheet. In this case I want to give the names of my ranges at the top of the Sub, then have the VBA code loop through only those ranges and perform the procedure. Is this even possible?

The procedure asks the user how many rows to add to the range (in this case the range is named "_2530_kp1"), then it adds the number of rows selected and re-numbers them for visual clarity (in this case the range the numbers are added into is named "_2530_kps_count".

----------------------------------------------------------------------------------

Please Login or Register  to view this content.

Moderator Note:

Pls use code tags around your code next time as per forum rules.