Excel VBA将变量设置为工作表(Excel VBA To Set Variable To Worksheet)

 我试图将一个Worksheet变量设置为活动Worksheet ，但我收到错误 
 
 
 
 对象变量或未设置块变量 
 
 
 这是我的语法 - 这样做的恰当方法是什么？ 
 
Sub TestIt()
 Dim ws2 As Worksheet, ws1 As Worksheet

  ws2 = ActiveWorkbook.ActiveSheet
  ws1 = "Belgium"

  Debug.Print ws2
  Debug.Print ws1
End Sub

I am trying to set a Worksheet variable to the Activesheet but I am getting an error of
 
 
 
Object variable or with block variable not set
 
 
This is my syntax - what is the appropriate way of doing this?
 
Sub TestIt()
 Dim ws2 As Worksheet, ws1 As Worksheet

  ws2 = ActiveWorkbook.ActiveSheet
  ws1 = "Belgium"

  Debug.Print ws2
  Debug.Print ws1
End Sub

原文：https://stackoverflow.com/questions/42869628