locked
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.

    Thankyou
    • 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