Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
VBA Code to change sheet names
Tony What I am trying to do is change the worksheet tab names according to the shift that is selected and show the proper start day (i.e., Fri, Thu, Tue) without generating a error. What I have put together works if ran in the proper order, but if I run it out of order I get a Run-Time 9 (out...- Restitus
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
VBA Code to change sheet names
I have created a work schedule that has to change worksheets names according to the shift working, basically a 7 day shift showing the respective shift, in proper day order; Days, Evenings, & Split Shift. This is the code that I have put together, (see below), my problem is that I can't get...- Restitus
- Thread
- Replies: 4
- Forum: VBA Visual Basic for Applications (Microsoft)
