Excel VBA⮱⮱001【单元格引用方式】 2019-12-
2019-12-27 本文已影响0人
平知
-
1 range(" ")方式引用
注意:range前面不加限定,默认表示在当前活动的工作表中引用:
![](https://img.haomeiwen.com/i15359095/c950a50fbbab19fc.png)
注意:
![](https://img.haomeiwen.com/i15359095/a80070a281fdf3ce.png)
![](https://img.haomeiwen.com/i15359095/8e92dbed0ac7f168.png)
◆ 1、引用一个单元格
Range("a1").Select
'选中一个单元格
![](https://img.haomeiwen.com/i15359095/25315d66eef14f0e.png)
◆ 2、引用一列(多列)
Range("a:a").Select
'选中一列
![](https://img.haomeiwen.com/i15359095/c3a5838b574f7501.png)
Range("a:c").Select
'选中多列
![](https://img.haomeiwen.com/i15359095/e55b3f2bd8f6a822.png)
◆3、引用一行(多行)
Range("1:1").Select
'选中一行
![](https://img.haomeiwen.com/i15359095/0f6f83ea50d044bb.png)
Range("1:4").Select
'选中多行
![](https://img.haomeiwen.com/i15359095/d2b267f848bb41da.png)
◆ 3、引用一块区域
Range("a1:c5").Select
'引用一块连续区域(左上角+右下角单元格位置)
![](https://img.haomeiwen.com/i15359095/3aa3ceff625024c9.png)
Range("a1", "b4").Select
'引用一块连续的变体
![](https://img.haomeiwen.com/i15359095/478400b73224753d.png)
Range(Range("a1"), Range("d5")).Select
'引用一块连续的变体之2
![](https://img.haomeiwen.com/i15359095/af1c94f815f206e3.png)
◆ 4、引用二块区域
, 逗号 = 二块区域的并集
Range("a1:c5,b3:e9").Select
'引用二块区域
![](https://img.haomeiwen.com/i15359095/1622c030a302af37.png)
空格 = 二块区域的交集
![](https://img.haomeiwen.com/i15359095/329a7ed90a5d2d14.png)
◆ 5、对range引用的区域赋值
Range("a1") = 111
'对一个单元格赋值
![](https://img.haomeiwen.com/i15359095/f88c9a68fc45e35d.png)
注意此时上条语句的select还在起作用之中。
Range("a1:b10") = 222
'对一块单元格赋值
![](https://img.haomeiwen.com/i15359095/23be2b1f5d77082a.png)
注意此时上条语句的select还在起作用之中。
◆ 6、使用字符串变量引用range()
![](https://img.haomeiwen.com/i15359095/7ade823f543a8951.png)
![](https://img.haomeiwen.com/i15359095/eb5a0cd2d6c56754.png)
![](https://img.haomeiwen.com/i15359095/470ca7d8cb6ce352.png)