How do I name a Workbook Sheet tab with a reference to data within that sheet in a macro?
S Scott Isaacs Apr 28, 2009 #1 How do I name a Workbook Sheet tab with a reference to data within that sheet in a macro?
H Heera Chavan Apr 28, 2009 #2 if suppose A1 has the name in sheet. Sub sheetnamemacro() Range("A1").select activesheet.name = activecell.value End Sub
if suppose A1 has the name in sheet. Sub sheetnamemacro() Range("A1").select activesheet.name = activecell.value End Sub
S Scott Isaacs Apr 28, 2009 #3 Yep...that worked, thank you Heera Heera Chavan said: if suppose A1 has the name in sheet. Sub sheetnamemacro() Range("A1").select activesheet.name = activecell.value End Sub Click to expand...
Yep...that worked, thank you Heera Heera Chavan said: if suppose A1 has the name in sheet. Sub sheetnamemacro() Range("A1").select activesheet.name = activecell.value End Sub Click to expand...
