VBA to Rename Excel Worksheet Value of Cell.

[[email protected]]

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

[Paul B]

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


<[email protected]> wrote in message
news:[email protected]...
> 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
>

[[email protected]]

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
>
>
> <[email protected]> wrote in message
> news:[email protected]...
> > 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
> >

[Sasa Stankovic]

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

<[email protected]> wrote in message
news:[email protected]...
> 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
>

[Sasa Stankovic]

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

<[email protected]> wrote in message
news:[email protected]...
> 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
>

[hpindoria]

what is that cell contains a date (format is DD/MM/YYYY) that format is not accepted in changing the sheet name so how would i change the format in the code