|
代码简单,就不上文件了,麻烦各位随便用一个工作表模块试一下。
union联合了第1和第5行,那么selectedRng.Rows.Count就应该是2。实际上无论联合了多少行,union联合后都是1行。
Sub test1()
Dim selectedRng As Range
Set selectedRng = Rows(1)
Set selectedRng = Union(selectedRng, Rows(5))
Debug.Print selectedRng.Rows.Count
End Sub
除非,union联合的区域本来就上下连在一起,比如下面的代码就能正确显示4。
Sub test2()
Dim selectedRng As Range
Set selectedRng = Rows(1)
Set selectedRng = Union(selectedRng, Rows(2))
Set selectedRng = Union(selectedRng, Rows(3))
Set selectedRng = Union(selectedRng, Rows(4))
Debug.Print selectedRng.Rows.Count
End Sub
|
|