In Excel is there a way to read the name of the sheets tab and di.

N

Neil

I would like to display the name of the sheet (the tab name) in a cell - or
vise versa. So the user could change it just once.
 
G

Gord Dibben

Which takes care of putting the sheet name in a cell.

For the vice versa.........

Sub SheetName22()
ActiveSheet.Name = Range("c1")
End Sub

Gord Dibben Excel MVP
 

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

Update several ppt documents from a single excel file 0
Merging from an Excel file with graphics 1
renaming tabs to fit formulas 0
How to get range names to Apply across multiple tabs 1
Variable to rename a tab in a worksheet via VBA 5
Sub projects added as read only in Master file which are saved on sharepoint 1
Style Gallery View 3
Converting excel to PDF, single page converts to multiple HELP! 1

Top