Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How to insert tab name in the sheet by formula?

Microsoft Excel Computer Science Microsoft Office Computer Skills
user-image
Question added by Jahafer Sadique , Senior Quantity Surveyor , Ahmed Mansoor Al Aali
Date Posted: 2015/12/13
Upvote (0) Views (4) Followers (2) Answers (2) Report Question
Write an Answer
Register now or log in to answer.
Sameh Helmy
by Sameh Helmy , مهندس مدنى , شركة الإسكندرية للإنشاءات ( طلعت مصطفي )

Use the above formula using either a button or sheet activate or you can use a module.

 

Praveen Varote
by Praveen Varote , HR Operations Manager , Myspace Retail Services

Formula:- Sheets("Sheet1").Name = "SheetName"

 

Sheet1 = is the worksheet you want to change the name for.

SheetName = is the name you want to change with.

Use the above formula using either a button or sheet activate or you can use a module.

Write Your Answer
More Questions Like This