In my attached workbook I have a selection of years with certain results in them.
For each worksheet, I run a macro that when it finishes, activates the next sheet and I run the
macro again. That means I am pushing the run macro button 5 times in each workbook.
How do I add to the code so that it runs the macro, finishes, goes to the next sheet and runs the macro again
until it has been through all 5 work sheets, without my interference.
I think you would use a Loop, but I wouldn't know where to begin.
My VBA skills are very amateurish.
Bookmarks