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?

user-image
Question added by Jahafer Sadique , Senior Quantity Surveyor , Ahmed Mansoor Al Aali
Date Posted: 2015/12/13
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.

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.