locked
How to get name of sheet RRS feed

  • Question

  • Hi,
    I want to get the name of the current active sheet in excel, not the name of the sheet ( funds, budget etc) but the name you see in the vba editor, for example Sheet49, sheet32 etc. How do I do this?

    Regards

    Robert


    Monday, July 6, 2009 3:01 PM

Answers

  • Below gives the name you are looking for: ActiveSheet.CodeName
    Monday, July 6, 2009 3:13 PM

All replies

  • Below gives the name you are looking for: ActiveSheet.CodeName
    Monday, July 6, 2009 3:13 PM
  • Thanks,

    you have helped me a million.

    Regards

    Rob
    Monday, July 6, 2009 3:18 PM