Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet names
Afternoon All
Have looked through some of the previous threads but cant find exactly what i am looking for. Can I change part of a sheet name eg Gauge Recal 06-01-06 to Thread Recal 06-01-06? In addition do this for all sheet names with Gauge at the front? TIA Ajay |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet names
One way:
Public Sub ChangeGaugeToThread() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets With ws If .Name Like "Gauge*" Then _ .Name = "Thread" & Mid(.Name, 6) End With Next ws End Sub In article , "Ajay" wrote: Afternoon All Have looked through some of the previous threads but cant find exactly what i am looking for. Can I change part of a sheet name eg Gauge Recal 06-01-06 to Thread Recal 06-01-06? In addition do this for all sheet names with Gauge at the front? TIA Ajay |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet names
Excellent so simple
Many thanks Ajay "JE McGimpsey" wrote: One way: Public Sub ChangeGaugeToThread() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets With ws If .Name Like "Gauge*" Then _ .Name = "Thread" & Mid(.Name, 6) End With Next ws End Sub In article , "Ajay" wrote: Afternoon All Have looked through some of the previous threads but cant find exactly what i am looking for. Can I change part of a sheet name eg Gauge Recal 06-01-06 to Thread Recal 06-01-06? In addition do this for all sheet names with Gauge at the front? TIA Ajay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automating Worksheet Names | Excel Worksheet Functions | |||
Lookups using worksheet names | Excel Discussion (Misc queries) | |||
Dynamic Worksheet Names | Links and Linking in Excel | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Indirect reference from one worksheet to another | Excel Worksheet Functions |