View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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.