Sheet name

    Hi there


    I want to rename an Excel Sheet. I have the name in a cell. Is it possible to link the Sheet name to a cell?


    Alring

    Re: Sheet name


    see if this helps you


    Code
    Private Sub Worksheet_Change(ByVal Target As Range)
Sheet1.Name = Sheet1.Range("A2").Value
End Sub



    pangolin

    Re: Sheet name


    Hi pangolin


    Thank you for your reply. It is working perfect for me. :rock: But you probely already new that.


    :thanx:


    Alring

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login