excel - 如何在Excel中激活特定工作表？(How to activate a specific worksheet in Excel?)

Question

I just need to activate a certain worksheet.

(我只需要激活某个工作表。)

I have a string variable that keeps the name of the worksheet.

(我有一个字符串变量，保留工作表的名称。)

  ask by Alex translate from so

Answer 1

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.

(基本上你想要使用.Activate函数。)

Or you can use the .Select function like so:

(或者您可以像这样使用.Select函数：)

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