随笔分类 -  VB

摘要:expression.Address(RowAbsolute, ColumnAbsolute, ReferenceStyle, External, RelativeTo)expression 必需。该表达式返回上面的对象之一。RowAbsolute Variant 类型,可选。如果为 True,则以绝对引用方式返回对行的引用。 默认值为 True。ColumnAbsolute Variant 类型,可选。如果为 True,则以绝对引用方式返回对列的引用。默认值为 True。ReferenceStyle XlReferenceStyle 类型,可选。XlReferenceStyle 可为以下 . 阅读全文
posted @ 2013-01-24 09:56 nchxmoon 阅读(464) 评论(0) 推荐(0)
摘要:Dim arr As Variant ReDim arr(3, 4) Dim row As Long Dim col As Long row = UBound(arr, 1) col = UBound(arr, 2) 阅读全文
posted @ 2013-01-22 13:11 nchxmoon 阅读(7807) 评论(0) 推荐(0)