Rename Multiple Worksheet Tab Names

[c0087]

I need to add the text "ABC" to the end of some worksheet tabs that already have names. It's a couple hundred sheets in the middle of a large spreadsheet, so I cant use code that selects the entire workbook. Thanks

 

[Rick Rothstein]

I need to add the text "ABC" to the end of some worksheet tabs that already have names. It's a couple hundred sheets in the middle of a large spreadsheet, so I cant use code that selects the entire workbook. Thanks

I think you will need to explain what I highlighted in red in more detail if you expect someone to be able to help you. What do you mean by "names" and how are the names of these tabs different from the names of other tabs?

 

[c0087]

I think you will need to explain what I highlighted in red in more detail if you expect someone to be able to help you. What do you mean by "names" and how are the names of these tabs different from the names of other tabs?

the sheet names are different serial numbers (not Sheet1, Sheet2, etc), and are different from the rest of the workbook. I have them in a notepad in case I need to copy/past them for reference. I'm looking to add "ABC" to the end of a couple hundred of them via vba, as to not have to manually ad it in. sorry for the insufficient details in the first post.

 

[Rick Rothstein]

the sheet names are different serial numbers (not Sheet1, Sheet2, etc), and are different from the rest of the workbook. I have them in a notepad in case I need to copy/past them for reference. I'm looking to add "ABC" to the end of a couple hundred of them via vba, as to not have to manually ad it in. sorry for the insufficient details in the first post.

Still insufficient detail... while I know you know what your serial numbers look like, we don't. If we are going to be able to pick them out from among the non-serial number tab names, we need to know their construction (all digits? a specific pattern of digits and letters and, perhaps, punctuation? etc.?). In other words, we need to understand in what way your serial numbers differ from your non-serial numbers.

 

[c0087]

Still insufficient detail... while I know you know what your serial numbers look like, we don't. If we are going to be able to pick them out from among the non-serial number tab names, we need to know their construction (all digits? a specific pattern of digits and letters and, perhaps, punctuation? etc.?). In other words, we need to understand in what way your serial numbers differ from your non-serial numbers.

here's the list.

3002
3003
3004
3005
3006
3007
3008
3009
3010
3011
3012
3013
3014
3015
3016
3017
3018
3019
3020
3021
3022
3023
3024
3025
3026
3027
3028
3029
3030
3031
3032
3033
1.6
1.7
1.8
1.9
2.6
2.7
2.8
2.9
3.6
3.7
3.8
3.9
4.6
4.7
4.8
4.9
5.6
5.7
5.8
5.9
6.6
6.7
6.8
6.9
7.6
7.7
7.8
7.9
8.6
8.7
8.8
8.9
9.6
9.7
9.8
9.9
10.6
10.7
10.8
10.9
11.6
17.17
17.27
17.37
17.47
17.57
17.67
17.77
17.87
17.97
18.07
18.17
18.27
18.37
18.47
18.57
18.67
18.77
18.87
18.97
19.07
19.17
19.27
19.37
19.47
19.57
19.67
19.77
19.87
19.97
20.07
20.17
20.27
20.37
20.47
20.57
20.67
20.77
20.87
20.97
21.07
21.17
21.27
21.37
21.47
21.57
21.67
21.77
21.87
21.97
22.07
22.17
22.27
22.37
22.47
22.57
22.67
22.77
22.87
22.97
23.07
23.17
23.27
23.37
23.47
23.57
23.67
23.77
23.87
23.97
24.07
24.17
24.27
24.37
24.47
24.57
24.67
24.77
24.87
24.97
25.07
25.17
25.27
25.37
25.47
25.57
25.67
25.77
25.87
25.97
26.07
26.17
26.27
26.37
26.47
26.57
26.67
26.77
26.87
26.97
27.07
27.17
27.27
27.37
27.47
27.57
27.67
27.77
27.87
27.97
28.07