有时我使用
Dim r as Range r =范围(A1)其他时间我使用
设置r =范围(A1)<有什么区别?什么时候应该使用什么?
解决方案没有理由使用 set 除非引用对象引用。在这种情况下只能使用它是一个很好的做法。对于所有其他简单的数据类型,只需使用赋值运算符。这是一个好主意, dim (维)所有变量:
简单数据类型的示例将是 integer , long , boolean , string 。这些只是数据类型,没有自己的方法和属性。
Dim i as Integer i = 5 Dim myWord as String myWord =无论我想要什么对象的示例将是范围,工作表或工作簿。这些有自己的方法和属性。
Dim myRange as Range 设置myRange = Sheet1.Range(A1)如果您尝试使用没有 Set 的最后一行,VB将抛出错误。现在,您有一个对象声明您可以访问其属性和方法。
myString = myRange.Value
Pardon me as am a newbie in VBA.
Sometimes I use
Dim r as Range r = Range("A1")Other times I use
Set r = Range("A1")What is the difference? And when should I use what?
解决方案There's no reason to use set unless referring to an object reference. It's good practice to only use it in that context. For all other simple data types, just use an assignment operator. It's a good idea to dim (dimension) ALL variables however:
Examples of simple data types would be integer, long, boolean, string. These are just data types and do not have their own methods and properties.
Dim i as Integer i = 5 Dim myWord as String myWord = "Whatever I want"An example of an object would be a Range, a Worksheet, or a Workbook. These have their own methods and properties.
Dim myRange as Range Set myRange = Sheet1.Range("A1")If you try to use the last line without Set, VB will throw an error. Now that you have an object declared you can access its properties and methods.
myString = myRange.Value
更多推荐
vba中的dim和set之间有什么区别?
发布评论