Question

Excel VBA 类型不匹配

Sub ExportLog(ByVal targetSheet As Object)

Sub aa()
Dim ws As Worksheet
Set ws = Worksheets("问题跟踪")
Call ExportLog(ws)
End Sub

Answer 1

Sub ExportLog(ByVal targetSheet As Object)
MsgBox "OK"
End Sub

Sub aa()
Dim ws As Worksheet
Set ws = Sheets("问题跟踪")
Call ExportLog(ws)
End Sub
的确奇了怪，在第一次运行时是出错提示不匹配，后来改了一下可以运行了，然后再改回原来的也可以通过了。。。妖怪了