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?


  • Re: Sheet name

    see if this helps you

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


  • Re: Sheet name

    Hi pangolin

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



Participate now!

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