Function test(sht As worksheet)
Application.displayalerts=false
sht. delete
Application.displayalerts=true
End Function
Sub 调用()
test Sheet2
End Sub
谢谢大神
...全文
3154打赏收藏
VBA自定义函数运行显示“类型不匹配”什么原因?
大神请指导下,自定义函数运行显示“类型不匹配”? 跟着网上视频走的,视频里运行没问题,代码如下: Function test(sht As worksheet) Application.displayalerts=false sht. delete Application.displayalerts=true End Function Sub 调用() test Sheet2 End Sub 谢谢大神