dstrickland91
New Member
- Joined
- Jun 12, 2015
- Messages
- 19
I make a workbook close to everyday with 26 sheets inside of it. Each sheet is named with a number. Im trying to find a piece of code that will insert a letter in backwards alphabetical order in front of each sheet name. For example my tab names are:
45
54
78
65
13
35
75
14
88
After the code runs, id like this to be the result.
Z45
Y54
X78
W65
V13
U35
T75
S14
R88
The numbers are different everyday so the code has to only insert the letter into the tabname. I used kutools addin and it was doing the trick, but A: it was slightly buggy, B: I didnt want to pay the software cost for that one feature. Id much rather have the piece of code that I can add in to work with my other modules.
Is this possible?
45
54
78
65
13
35
75
14
88
After the code runs, id like this to be the result.
Z45
Y54
X78
W65
V13
U35
T75
S14
R88
The numbers are different everyday so the code has to only insert the letter into the tabname. I used kutools addin and it was doing the trick, but A: it was slightly buggy, B: I didnt want to pay the software cost for that one feature. Id much rather have the piece of code that I can add in to work with my other modules.
Is this possible?