Naming Tabs with a reference using a Macro
 

How do I name a Workbook Sheet tab with a reference to data within that sheet
in a macro?

Naming Tabs with a reference using a Macro
 

if suppose A1 has the name in sheet.

Sub sheetnamemacro()

Range("A1").select
activesheet.name = activecell.value

End Sub

"Scott Isaacs" wrote:

How do I name a Workbook Sheet tab with a reference to data within that sheet
in a macro?

Naming Tabs with a reference using a Macro
 

Yep...that worked, thank you Heera

"Heera Chavan" wrote:

if suppose A1 has the name in sheet.

Sub sheetnamemacro()

Range("A1").select
activesheet.name = activecell.value

End Sub

"Scott Isaacs" wrote:

How do I name a Workbook Sheet tab with a reference to data within that sheet
in a macro?