Sorry , many similar but different questions.
I have a workbook with e.g 40 worksheets from wich the first 10? are for calculations and taking values from the last 30 ( last 30 have names like Sheet11='Team1' , Sheet12='Team2' to last sheet with name 'Team30'.
1. I want to run the macro 'clearcells1' to all the last 30 sheets, or to run the macro 'clearcell1' to all the sheets to the right (from the active sheet- if the active sheet is the tenth , it will run to the next-last 30 sheets-same as previus e.g.)
2. Run the macro 'clearcells1' to cells e.g. 21 to 23 .(Team11!, Team12!, Team13!). The values 21/23 to be changed inside the code manually. Something like range in sheets.
I have a large file and with macro 'clearcells1' i find blank cells, delete emty rows, copy, special paste values etc in sheets e.g. 11 to 40 (reduse size)
3. In fact what i do is copy the 10nth sheet (the master-large sheet-many formulas) paste it to 11nth sheet (Team1!) , then run the macro 'clearcells1' to reduce the file size (avoid memory problems-delays) then copy again the 10nth sheet (the master) and paste it now to 12nth sheet (Team2!) and so on to the last sheet.
The number of sheets are variable but don't change during one session ( i open the file and there are e.g. 40 standar sheets - values inside cells only change). I tried to record a macro but it copies the master sheet always to the 11nth sheet.
Although an answer to the 3rd question would be exactly what i need, i would appreciate answers to the first/second question, i believe that are things i would need-use in the near future.
Thank a lot ( took me half an hour to type it)
I have a workbook with e.g 40 worksheets from wich the first 10? are for calculations and taking values from the last 30 ( last 30 have names like Sheet11='Team1' , Sheet12='Team2' to last sheet with name 'Team30'.
1. I want to run the macro 'clearcells1' to all the last 30 sheets, or to run the macro 'clearcell1' to all the sheets to the right (from the active sheet- if the active sheet is the tenth , it will run to the next-last 30 sheets-same as previus e.g.)
2. Run the macro 'clearcells1' to cells e.g. 21 to 23 .(Team11!, Team12!, Team13!). The values 21/23 to be changed inside the code manually. Something like range in sheets.
I have a large file and with macro 'clearcells1' i find blank cells, delete emty rows, copy, special paste values etc in sheets e.g. 11 to 40 (reduse size)
3. In fact what i do is copy the 10nth sheet (the master-large sheet-many formulas) paste it to 11nth sheet (Team1!) , then run the macro 'clearcells1' to reduce the file size (avoid memory problems-delays) then copy again the 10nth sheet (the master) and paste it now to 12nth sheet (Team2!) and so on to the last sheet.
The number of sheets are variable but don't change during one session ( i open the file and there are e.g. 40 standar sheets - values inside cells only change). I tried to record a macro but it copies the master sheet always to the 11nth sheet.
Although an answer to the 3rd question would be exactly what i need, i would appreciate answers to the first/second question, i believe that are things i would need-use in the near future.
Thank a lot ( took me half an hour to type it)