I have a workbook with 30+ worksheets
named 23 Wed, 24 Thur, 25 Fri, etc etc
meaning April 23, 2014 Wednesday, April 24, 2014 Thursday, etc etc
The next project may start on May 19, 2014 Monday - so I have to rename each worksheet
beginning with 19 Mon, etc etc
Renaming each worksheet manually takes a long time and is prone to error
I would like to just rename the first worksheet to start date of May 19, 2014 and have the rest renamed automatically.
Is there anyway to do this ?
Can't be done using formula's but can be done using VBA. Let us know if you are ok for it
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
A looong time ago I was a wizard in COBOL, FORTRAN, and APL.
I could make a mainframe sing.
BUT I got promoted and haven't written a line of code since.
I did find the Right-Click on Tab / View Code / brings up a box that looks like it wants VB code.
but I really don't know the syntax.
So, I guess my answer is Yes and No, depending upon how easy the "programmette" would be.
How to install your new code
- Copy the Excel VBA code
- Select the workbook in which you want to store the Excel VBA code
- Press Alt+F11 to open the Visual Basic Editor
- Choose Insert > Module
- Edit > Paste the macro into the module that appeared
- Close the VBEditor
- Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
To run the Excel VBA code:
- Press Alt-F8 to open the macro list
- Select a macro in the list
- Click the Run button
Please Login or Register to view this content.
Try this..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks