VBA Worksheet change name

  • Thread starter Thread starter James C
  • Start date Start date
J

James C

I wish to change the name of a worksheet (Which name can be varied) to
apredetermined name say Sheet1.

I particular wish this be done within a VBA statement. I have one macro
that affects several workbooks and consequently the worksheets will have
different names and I wish to use a one predetermined name to cover this
variation.

Thanks
 
You can rename the worksheet with code like

Worksheets("OldName").Name = "NewName"

If you want to get the new name from a cell value, use something like

Worksheets("OldName").Name = Range("A1").Text

Cordially,
Chip Pearson
Microsoft MVP 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
[email on web site]
 
How about using ActiveSheet in your code?

Or refer to the sheet codename

Worksheets(1) ignores the actual sheet name displayed on the sheet tab.


Gord Dibben MS Excel MVP
 

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Setting Scope of name ranges to particular worksheet 2
paste-link tab name via vba editor 1
VBA - retrieve data on last create named range from previous inserted named range 0
Macro to create validation list of worksheet names 1
Ref Formula 4
Confusion with Names 1
Moving a range name AND Contents 2

Back
Top