问题描述
很抱歉,如果已经回答了这个问题,但是我没有运气去寻找.
I apologize if this has already been answered, but I had no luck searching on this.
当工作表被变量引用时,访问工作表属性的最佳方法是什么?
What’s the best way to access a worksheet property, when the worksheet is referenced by a variable?
这引发了一个编译错误:
This one raises a compile error:
Sub Tst1(Wk As Worksheet)
Debug.Print Wk.pbOK
End Sub
此方法有效,但是有更好的方法吗?谢谢.
This one works, but is there a better way? Thanks.
Sub Tst2(Wk As Object)
Debug.Print Wk.pbOK
End Sub
推荐答案
通过KazJaw的提示,发现在以下情况下,您可以编译该文件没有问题:
With a tip from KazJaw, found out that you can get it compile no issues if:
Sub Tst1(Wk As Worksheet)
Debug.Print Thisworkbook.Worksheets(Wk.Name).pbOK
End Sub
我能想到的此方法的唯一用途是存储已处理的宏的状态(或将工作表标记为在会话中已处理),因为重新打开工作簿后不会保存值.
The only usefulness of this method i can think of is to store the state of macro processed (or mark worksheet as processed at a session), as values does not get saved after the workbook is re-opened.
这篇关于使用工作表变量获取工作表属性的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!