How to activate a specific worksheet in Excel?

Alex picture Alex · Oct 25, 2010 · Viewed 780.2k times · Source

I just need to activate a certain worksheet. I have a string variable that keeps the name of the worksheet.

Answer

Dennis G picture Dennis G · Oct 25, 2010

Would the following Macro help you?

Sub activateSheet(sheetname As String)
'activates sheet of specific name
    Worksheets(sheetname).Activate
End Sub

Basically you want to make use of the .Activate function. Or you can use the .Select function like so:

Sub activateSheet(sheetname As String)
'selects sheet of specific name
    Sheets(sheetname).Select
End Sub