Hello!
I wodner if I can search and replace certain keyword in all worksheet tabs?
Lets say I have these tabs:
MODEL1
MODEL2
MODEL3
Can I replace MODEL with SYSTEM ?
Thanks!!!
Dorian
Hello!
I wodner if I can search and replace certain keyword in all worksheet tabs?
Lets say I have these tabs:
MODEL1
MODEL2
MODEL3
Can I replace MODEL with SYSTEM ?
Thanks!!!
Dorian
try this. Sample file attached. Run macro "Rename_Sheets"
[ATTACH]n1201220[/ATTACH]
Fantastic - it works seamlessly - thanks a lot!
can you please help me update this wonderful macro to cycle thgrough the names in column A on tab names and save the workbook after each cycle run with the name used to renbame the sheets?
names on tab now: [TABLE="border: 0, cellpadding: 0, cellspacing: 0, width: 48"]
[TD="width: 64"]set1[/TD]
set2
[/td]set3
[/td]set4
[/td]set5
[/td]set6
[/td]set7
[/td]set8
[/td]set9
[/td]set10
[/td]set11
[/td]set12
[/td]set13
[/td]set14
[/td]set15
[/td]set16
[/td]set17
[/td]set18
[/td]set19
[/td]set20
[/td]
[/TABLE]
so it woudl rename all sheest with set1 and save the workbook as set1.xlsx and then go to set2
can it be done?
here is the update file:
[ATTACH]n1212843[/ATTACH]
I don't understand what you mean because you can't have the same name for a tab so you can't have two sheets named as "set1" in the same file
Don’t have an account yet? Register yourself now and be a part of our community!