Hi everyone,
I've never ran into this issue before. I'm trying to create an array of worksheets to run one of my macros. The worksheet names change every now and then, but they ones I need are always in-between two specific worksheets. THe workbook is structure this way:
Worksheet(1) = "Reps Start Here"
Worksheets(2) - Worksheets(I)
Worksheet(end) = "Reps Stop Here"
So, between worksheets "Reps Start Here" and "Reps Stop Here" are the worksheet names I need to create an array from. Any idea how I can do that?
Thanks!!!
Bookmarks