VBA for sheet names??

A

Andre Croteau

Hi (again),

Is it possible to have a VBA macro that could change the sheet names, based
on text in certain cells?

Suppose I have in SHEET1 cell C2 : CANADA
C3 : AUSTRALIA
C4 : NETHERLAND


The macro would modify the sheet names : sheet2 would become CANADA

sheet3 would become AUSTRALIA

sheet4 would become NETHERLAND



Then, if I changed cell c4 to ENGLAND, running the macro would modify the
NETHERLAND sheet to one named ENGLAND.

Can anyone help?

Thanks

André
 

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

Code to format cells on several worksheets 2
Help changing the sheet name 3
Need Help with a VBA subroutine 0
VBA Coding Help for Beginner 0
Hyperlink via indirect cell reference 8
Macro to copy data X number of times into a column 0
Removing Intermediary Connections 2
Need formula to automatically populate Sheet 2 cells with same content as Sheet 1 1

Top