Select Current Sheet RRS feed

  • Question

  • Is there a command to select the sheet that I'm currently working on and to change its name?
    For example, my macro creates a sheet and then renames that sheet to a specific name. But the current sheet name won't always be the same, it can be for example Sheet3, Sheet4, Sheet5 ...

    If you have any questions please let me know.

    • Moved by Martin Xie - MSFT Monday, March 30, 2009 10:38 AM Move it to VBA forum for better support.
    Thursday, March 26, 2009 8:55 PM

All replies

  • Try this:

    ActiveSheet.Name = "NewName"

    Negative0 http://johnkoerner.com
    Sunday, March 29, 2009 1:04 AM