referring to tab label in formula

  • Thread starter Thread starter aben68
  • Start date Start date
This selects the sheet and then renames it.
Sub Macro1()
Sheets("Sheet1").Select
Sheets("Sheet1").Name = "SheetZ"
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using column labels instead of column numbers 1
referencing to matrix labels 4
Chart datalabels linked to cells 1
Remove All Tabs from Ribbon except Custom Tab 2
Change the "Labels in Formulas" function to an add-in. 3
Excel 2007 labels in formulas no longer supported! 1
Goto Reference:="abc" where abc is formula result 5
Refer to sheets without using tab name?? 4

Back
Top