How to change the ActiveSheet tab ("Plan1")

  • Thread starter Thread starter Paulo de Arruda Borelli
  • Start date Start date
P

Paulo de Arruda Borelli

How can I change the active sheet's tabs? (the ones named "Plan1", "Plan2"
etc. by Excel)

Thank you
Paulo.
 
Hi Paulo,

You may try to use the code below.
Sub Test()
Dim ws As Worksheet
Set ws = Application.ActiveSheet
ws.Name = "hello"
End Sub

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Hi Paulo,

If you still have any concern on this issue, please feel free to post here.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top