How to Activate a Sheet using VBA


Let’s say you are working with multiple worksheets, and for you, it’s hard to navigate to a sheet using tab. In this situation, you can use a VBA code to activate any worksheet.

And, to write a VBA code for this you need to use Worksheet.Activate Method. In this post, I’d like to share with you a simple way to write this code to activate or select a worksheet. Before you write this code, you need to understand this method.

Worksheet.Activate Method

In this method, you can specify worksheet’s name or number which you want to activate. Let’s say if you need to activate sheet1, then the code will be:


Or you can use sheet number as well.


So the final code will be:

Sub ActivateSheet1()
End Sub

Examples: Activate a Worksheet with VBA

In the real life, you can use this method in different ways. Here are some of them.

1. Activate a