I'm working on a project that requires 191 tabs. My first tab has the totals, summed from the following 190 tabs. My first tab is named "TOTAL". The additional tabs need to be names for the apartment number in the building. For example 501, 502, 503, etc. Without physical clicking add tab 190 time and renaming it 190 times, is there a faster way to do it?
Put in a standard module, change the range of numbers (apartment numbers) and run:
abousetta
Please Login or Register to view this content.
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
Just a bit of input here. Are you really sure you need 190 sheets for this? They will be a nightmare to find and work with.
This sounds like the classic error of designing what you want the output to be, before designing an easy input method.
Without knowing what you want to do, I have a feeling that it will be simpler to have 1 data input sheet for all rooms, and then additional sheet/s for your summary/analysis.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Completely agree with Ford.
But you may try this......
Open your workbook --> Press Alt+F11 to open VBA Editor --> Insert (on VBA editor) --> Module --> Paste the code given below on the opened code window --> Now Press F5 (Function Key) to run the code --> After the sheets are added, select the code and delete it ( I assume that you will not need it after adding the sheets) -->Done.
You may change the numbers in red as per your requirement.Please Login or Register to view this content.
Last edited by sktneer; 10-01-2014 at 08:48 AM. Reason: Made correction in code as pointed out by abousetta.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
sktneer, ShNum should be Long as the OP is using Excel 2010. Excel will automatically convert integers to long so should code it that way to begin with.
Thanks for pointing this out. I really didn't notice it. Thanks once again.Originally Posted by abousetta
Yes, I read that it actually speeds up the code because when declaring it as long to begin with Excel doesn't have to spend time reassigning memory to the variable. Of course if there is going to be a mix of users (e.g. 2003 and 2010) then it becomes a judgment call.
As you can see I am still using Excel 2007 so not very much aware of the fact that how 2010 deals with the variables and data types.
But thanks to Gurus like you who are always there to tell you right and wrong and guide you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks