I've been trying all morning to find a way to simply change the names shown on the worksheet tabs from Sheet1..etc, to the numbers 1, 2, 3..etc. up to 31. Each tab corresponds to a date within a month. I just can't seem to find VBA code for something as deceivingly simple as this! Thanks in advance!
greveg
Hi,
The code is as follows :
Hope your search ends here.
Please Login or Register to view this content.
Happy Computing ,
Xlbiznes.
To show your appreciation please click *
Thank you so much for replying so quickly, Xlbiznes! I have not had a chance to try out your solution, as I am at work, but as soon as I can get to it, I will definitely let you know how it turned out and add to your reputation!
greveg
**Xlbiznes,
I went into the VBA editor for my worksheet and input the info that you gave me. It asks me to name the macros, and every time I try to name it it comes up with an Invalid Naming Error. Is there something I'm not understanding? I'm fairly new to editing Excel using VBA.
greveg
Last edited by greveg; 02-28-2013 at 08:29 PM.
I still have yet to figure the VBA coding out. Unfortunately, I just gave up and manually copied the my spreadsheet manually 30 times. Thanks for the attempt!
greveg
Did not see your post.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks