VBA Worksheet change name
in [General]
|
Prev: Excel 07 won't allow my Excel 03 files to link properly
Next: Issues with linking to exported source files
From: James C on 26 Jan 2010 10:57 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 -- James
From: Chip Pearson on 26 Jan 2010 11:32 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] On Tue, 26 Jan 2010 07:57:01 -0800, James C <JamesC(a)discussions.microsoft.com> wrote: >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
From: Gord Dibben on 26 Jan 2010 12:34
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 On Tue, 26 Jan 2010 07:57:01 -0800, James C <JamesC(a)discussions.microsoft.com> wrote: >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 |