Repeat code for multiple worksheets
Mike
I have no idea if your code will work on different sheets because you may
have sheet names in the code but this loops through all sheets except the
last 2
For x = 1 To Worksheets.Count - 2
'your macro
Next
Mike
"Mike" wrote:
Hi.
I have a set of code that I have written to execute on one worksheet of a
workbook. There are about 15 different worksheets in this workbook.
I need to have this code excecuted for all but 2 of the worksheets.
Is there a way I can loop the code so that I don't have to rewrite it for
each worksheet. Note that the two I do not need this run on are the last two
worksheets in the workbook.
Thanks,
Mike.
|