Linking worksheet tab names to a cingle cell

M

Manager

I have tried several VBA suggestions and for some reason the tab name
does not change.

I have tried the following:
ActiveSheet.Name = ActiveSheet.Range("A1").Value

Does the tab name need to be "Sheet1"?

In my case I am working with an existing spreedsheet and the tab names
have already been modified. I am attempting to ling to cell D4.

HELP
 

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

Crating User Form to Add Names 1
Document Merge Formatting Issue 0
How do I link a cell in a workbook? 1
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
How to link seperated documnet into a single document 0
Select Text to End of Footnote 9
Grouping Names in Mail Merge 0
Word 2016 - Difficulties Learning Style Creation/Application 0

Top