- Nov 22, 2009
- Office Version
I am working on a macro that creates from 4 to 12 worksheets. The number of worksheets created is dependent upon the data in the starting worksheet that has all of the data. So, sometimes it might be 4 sheets, sometimes 7 sheets, etc. I want to apply the same formatting to all of the NEW worksheets only. Without knowing the number of new sheets, or their names, how can I code this so that I can apply this same formatting to all my new sheets?