Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rename Multiple work sheet
I have around 10 worksheets .....5 contains the word "[Trend]" in their
sheet name for example "Product1 [Trend]" I want a Macro that can search for word "[Trend]" in available worksheets and delete this word or replace it with some other text..so that worksheet rename as "Product1". Is it possible...? Thank you, Murtaza |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i rename a sheet if the rename tab is inactive? | Excel Worksheet Functions | |||
multiple work sheet data to link in one worksheet | Excel Worksheet Functions | |||
need a function that will work using multiple work books and sheet | Excel Worksheet Functions | |||
Multiple work sheet merge | Excel Discussion (Misc queries) | |||
Move data to new sheet - rename sheet based on criteria ? | Excel Discussion (Misc queries) |