| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
MACRO TO RENAME SHEET !
"Jay Dean" wrote in message om... No, I tried it but it did not work. Ahem - what happened? It works on my machine and Don Guillett posted almost identical code. BTW, you said that your spreadsheets are called Book1 and Book2. You may have meant Book1.xls and Book2.xls. Have you put the correct names in? GB "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 |
| Reply |
| 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 | |||
Linear Mode
