| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MACRO TO RENAME SHEET !
No, I tried it but it did not work.
"GB" wrote in message ... Does this work? Workbooks("Book1").Sheets(1).Name = Workbooks("Book2").Sheets(2).Range("A1").Value GB "Jay Dean" wrote in message om... I have 2 Excel Workbooks -- Book1 and Book2. I want a code that will rename Sheet1 of Book1 whatever the value in cell A1 in Sheet2 of Book2 is. Any assistance would be appreciated. Thanks! Jay Dean |
| 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 | |||
| Macro REQ: Automatically copy a template sheet and rename | Excel Worksheet Functions | |||
| macro to: Add new sheet, then rename new sheet with todays date | Excel Worksheet Functions | |||
| Move data to new sheet - rename sheet based on criteria ? | Excel Discussion (Misc queries) | |||
| Macro to rename all worksheets with cell value in each sheet | Excel Programming | |||
Threaded Mode
