Tab Sheet Rename

Good day guys,

I have a little problem about renaming my 200 tabs sheet. I want to rename it based on active excel sheet in Column A against B. Column A contain the existing name while in Column B will be the new name. For example

A----------------------B
Tab1-----------------Arnold
Tab2-----------------Donald
Tab3-----------------Ann

I dont know if this is possible but I hope you guys can help me about this

Thank you so much

Junjie

Hi,

you can start by activating Macro Recorder and rename a tab : you will get a free base of code !

Sorry TMS

Do you have an answer in this question?

Thanks in advance

davesexcel - this what i am looking for.

thanks your a great man..

I will try this in my file

Davesexcel - I tried and it works,

Thanks a lot.

you make my day