| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Naming a sheet after a value in a cel of that sheet
Is there a way to name the sheet or a tab of the sheet with a value of a
cell on that sheet? ====== SNIP Cells.Select Selection.Copy Windows("Verification.xls").Activate ActiveSheet.Paste Range("A1").Select Sheets("Sheet6").Select Sheets("Sheet6").Name = "2" <<<===== manually added but the value is on cell D1 of that sheet. ====== SNIP Thanks!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Naming a sheet after a value in a cel of that sheet
Try
Worksheets("Sheet6").Name = Worksheets("Sheet6").Range("A1").Text -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Vispy" wrote in message ... Is there a way to name the sheet or a tab of the sheet with a value of a cell on that sheet? ====== SNIP Cells.Select Selection.Copy Windows("Verification.xls").Activate ActiveSheet.Paste Range("A1").Select Sheets("Sheet6").Select Sheets("Sheet6").Name = "2" <<<===== manually added but the value is on cell D1 of that sheet. ====== SNIP Thanks!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Naming a sheet after a value in a cel of that sheet
Worked great!!! Thanks!
"Chip Pearson" wrote in message ... Try Worksheets("Sheet6").Name = Worksheets("Sheet6").Range("A1").Text -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Vispy" wrote in message ... Is there a way to name the sheet or a tab of the sheet with a value of a cell on that sheet? ====== SNIP Cells.Select Selection.Copy Windows("Verification.xls").Activate ActiveSheet.Paste Range("A1").Select Sheets("Sheet6").Select Sheets("Sheet6").Name = "2" <<<===== manually added but the value is on cell D1 of that sheet. ====== SNIP Thanks!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lock tab in sheet 2 until cell in sheet one is completed | Excel Worksheet Functions | |||
| Index/Contents Sheet | Excel Discussion (Misc queries) | |||
| In Excel, how do you make one whole sheet equal to another. | Excel Discussion (Misc queries) | |||
| Clicking Cell Link Changes Cell on Another Sheet | Excel Discussion (Misc queries) | |||
| Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
Linear Mode
