Matt Miller
asked on
Copying and Saving Individual Workbooks into a New Workbook
Hello,
I have a macro that identifies sheets that need to be collected into an individual workbook. I was wondering if there was a way to use indexing or Worksheet Names to select those sheets to do activities on them.
Is there a way to take the beginning sheet and end sheet to select all the sheets inbetween or using a collection of names in a running string in between?
Thanks
I have a macro that identifies sheets that need to be collected into an individual workbook. I was wondering if there was a way to use indexing or Worksheet Names to select those sheets to do activities on them.
Is there a way to take the beginning sheet and end sheet to select all the sheets inbetween or using a collection of names in a running string in between?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I've requested that this question be closed as follows:
Accepted answer: 0 points for mattfmiller's comment #a40799399
for the following reason:
Absolutely perfect and straightforward.
Accepted answer: 0 points for mattfmiller's comment #a40799399
for the following reason:
Absolutely perfect and straightforward.
I'm glad it worked for you. Please use the Accept as Answer link on my post, not your own.
ASKER
Sorry I clicked on the wrong one.
ASKER