Is it possible to set the tab (worksheet) names equal to a cell?
C Chip Pearson May 26, 2006 #2 Only with VBA code. Sub AAA() Worksheets(1).Name = Worksheets(1).Range("A1").Value End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "higherlimits" in message news:[email protected]...
Only with VBA code. Sub AAA() Worksheets(1).Name = Worksheets(1).Range("A1").Value End Sub -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "higherlimits" in message news:[email protected]...
G Gary''s Student May 26, 2006 #3 Yes, but: 1. the cell must contain a legal tab name 2. tab names must be unique Sub Macro2() Sheets("Sheet1").Select Sheets("Sheet1").Name = Cells(1, 1).Value End Sub
Yes, but: 1. the cell must contain a legal tab name 2. tab names must be unique Sub Macro2() Sheets("Sheet1").Select Sheets("Sheet1").Name = Cells(1, 1).Value End Sub
