Hi All
I have been working on an array without success so I am having to start from scrath again.
Would anybody be able to assist me! I have a workbook which has several worksheets in it. What I want to do is go to a certain worksheet, with a workbook, say the "Data" worksheet, and store the name of the following worksheet in a variable, go to the next tab and store that name, go to the next one tab and store that one. I may end up with four or five max worksheet names. Then I would like to go to another workbook altogether, and goto the worksheet that I first stored in the array from the previous workbook.....do what I need to do and then go to the second name stored in the array...do what I want to do so on until I have done every name that was stored.
Any help wouold be greatfully received.
Kindest Regards
Peter
I have been working on an array without success so I am having to start from scrath again.
Would anybody be able to assist me! I have a workbook which has several worksheets in it. What I want to do is go to a certain worksheet, with a workbook, say the "Data" worksheet, and store the name of the following worksheet in a variable, go to the next tab and store that name, go to the next one tab and store that one. I may end up with four or five max worksheet names. Then I would like to go to another workbook altogether, and goto the worksheet that I first stored in the array from the previous workbook.....do what I need to do and then go to the second name stored in the array...do what I want to do so on until I have done every name that was stored.
Any help wouold be greatfully received.
Kindest Regards
Peter