Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |