G
Gary Keramidas
if i create 2 arrays from a range, is there a way to compare the entire array,
instead of element by element?
For i = 2 To lastrow
arr1 = ws.Range("c" & i & ":E" & i)
arr2 = ws.Range("c" & i - 1 & ":E" & i - 1)
i want to know when arr1 = arr2.
right now i just use a loop to check the elements and if they all match, i
continue on.
instead of element by element?
For i = 2 To lastrow
arr1 = ws.Range("c" & i & ":E" & i)
arr2 = ws.Range("c" & i - 1 & ":E" & i - 1)
i want to know when arr1 = arr2.
right now i just use a loop to check the elements and if they all match, i
continue on.