|
本帖最后由 lijian8003 于 2021-3-18 19:25 编辑
- Sub test()
- Application.ScreenUpdating = False
- Dim cell As Range, xRng1 As Range, xRng2 As Range
- Dim i As Integer
- i = 1
- Set xRng1 = Range("B1:B1000")
- Set xRng2 = Range("A1:A1000")
- For Each cell In xRng2
- If cell.Value <> "" And WorksheetFunction.CountIf(xRng1, cell.Value) = 0 Then
- If WorksheetFunction.CountIf(xRng2, cell.Value) > 2 Then Range("B" & i) = cell.Value: i = i + 1
- End If
- Next
- Application.ScreenUpdating = True
- End Sub
复制代码 问题一:列为变量
Range("B1:B1000")
Range("B" & i)
步长=1
B C D E F...依次各列的变量,如何表达?
Range("B1:B1000") Range("C1:C1000") Range("D1:D1000")...
Range("B" & i) Range("C" & i) Range("D" & i)...
问题二:行为变量
Range("A1:A1000")
步长=10
Range("A1:A1000") Range("A11:A1010") Range("A21:A1020")...
各行的变量,如何表达?
本帖最后由 砂海 于 2021-3-18 20:38 编辑
Cells 不用列标 , 比range容易控制
====================
Range("B3")
Cells( 3 , 2 )
------------------------------------------
Range("A1:C3")
Range(cells(1,1),cells(3,3)).Select
----------------------------------------------------------------------------------------------
也可以 range("A1").Offset( 偏移行 , 偏移列).resize( 行数 , 列数)来表达
|
|