| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Textbox value - rename worksheet with
I have 10 tabs that I will need to rename from a textbox (not the range in
the code below). The following code has to be ran first, then backtrack to rename the appropriate tabs to the value in the textbox. Anyone have any ideas? Range("P5:R5").Copy For sh = 2 To Sheets.Count If Sheets(sh).Name Like ("Request*") Then ActiveSheet.Paste Destination:=Sheets(sh).Range("P5:R5") End If Next End Sub |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rename Tab with Textbox on Worksheet | Excel Programming | |||
| rename the new worksheet | Excel Programming | |||
| Using information from one worksheet, to rename inserted worksheet | Excel Worksheet Functions | |||
| Rename the worksheet | Excel Discussion (Misc queries) | |||
| Rename Textbox on Worksheets | Excel Programming | |||
Threaded Mode
