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
 
Top