Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Repeat code for multiple worksheets
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Repeat code for multiple worksheets
This works great, Mike H. I just have the first statement be:
Sheets(x).select Thanks! "Mike H" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Information from multiple worksheets to repeat on a single one | Excel Discussion (Misc queries) | |||
Repeat same data entry to multiple worksheets without Group Functi | Excel Discussion (Misc queries) | |||
Code for multiple worksheets | Excel Discussion (Misc queries) | |||
Repeat printing rows in multiple worksheets | Excel Discussion (Misc queries) | |||
Delete Blank Rows Code - Multiple Worksheets - Multiple Documents | Excel Discussion (Misc queries) |