ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to change this into array ? (https://www.excelbanter.com/excel-programming/325677-how-change-into-array.html)

broogle

How to change this into array ?
 
For Each Cell In rngA
If Cell < "xxx" Then
With Cell
If Application.CountIf(rngZ, .Value) = 0 Then

Cells(rw, 3).Value = .Value
rw = rw + 1
End If

End With
End If

Next Cell


For Each Cell In rngB
If Cell < "xxx" Then
With Cell
If Application.CountIf(rngZ, .Value) = 0 Then

Cells(rw, 3).Value = .Value
rw = rw + 1
End If

End With
End If

Next Cell


For Each Cell In rngC
If Cell < "xxx" Then
With Cell
If Application.CountIf(rngZ, .Value) = 0 Then

Cells(rw, 3).Value = .Value
rw = rw + 1
End If

End With
End If

Next Cell


******** Thanks !!! ********



All times are GMT +1. The time now is 01:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com