VBA to Rename Excel Worksheet Value of Cell.
 

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

VBA to Rename Excel Worksheet Value of Cell.
 

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


wrote in message
oups.com...
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

VBA to Rename Excel Worksheet Value of Cell.
 

Perfect! Thanks!

Paul B wrote:
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


wrote in message
oups.com...
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

VBA to Rename Excel Worksheet Value of Cell.
 

Sub test()
Worksheets("current_name").Name=Range("c7").Value
End Sub

wrote in message
oups.com...
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