VBA to Rename Excel Worksheet Value of Cell.

  • Thread starter Thread starter idanovich
  • Start date Start date
I

idanovich

Hi,

I need to write a VBA program to rename a worksheet. The tricky part
is that I need it to be renamed to whatever a value is in a particular
cell. For example, if cell C7 says "Management" I want the worksheet
to be renamed "Management". Is this possible? Any help would be
great! Thanks.

-Idan
 
try this,

activesheet.name =[C7]


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Perfect! Thanks!

Paul said:
try this,

activesheet.name =[C7]


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


Hi,

I need to write a VBA program to rename a worksheet. The tricky part
is that I need it to be renamed to whatever a value is in a particular
cell. For example, if cell C7 says "Management" I want the worksheet
to be renamed "Management". Is this possible? Any help would be
great! Thanks.

-Idan
Click to expand...
Click to expand...
 
Back
Top