How to change the ActiveSheet tab ("Plan1")

  • Thread starter Paulo de Arruda Borelli
  • 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.
 
P

Peter Huang

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

Peter Huang

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