Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet tabs
I use Excel 2003. I have several worksheets with tabs for each day of the
month. Is there a way to run a find and replace of the month on all the worksheets in a workbook? (Example: the tab text is 01.dd.08. Goal -- replace all the 01 tabs text with 03 without clicking on and editing each tab individually.) -- SAK |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet tabs
Run this little macro:
Sub tabfixer() v = "03" For Each w In Worksheets n = w.Name w.Name = v & Right(n, 6) Next End Sub Next month just change the v= statement and run again -- Gary''s Student - gsnu200771 "SAK" wrote: I use Excel 2003. I have several worksheets with tabs for each day of the month. Is there a way to run a find and replace of the month on all the worksheets in a workbook? (Example: the tab text is 01.dd.08. Goal -- replace all the 01 tabs text with 03 without clicking on and editing each tab individually.) -- SAK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to name worksheet tabs using a cell within the worksheet? | Excel Discussion (Misc queries) | |||
Can Excel worksheet tabs be relocated above the worksheet? | Excel Discussion (Misc queries) | |||
Worksheet Tabs | Excel Discussion (Misc queries) | |||
Worksheet Tabs | Excel Discussion (Misc queries) | |||
Worksheet Tabs | Excel Discussion (Misc queries) |