Compare blocks of cells
Is there a quick way to compare a block of cells in a row without doing
something like
a = activecell.value
B= activecell.offset(0,1).value
c = activecell.offset(0,2).value
Different worksheet.
Range(A1).activate
if activecell.value = a and activecell.offset(0,1).value = b and
activecell.offset(0,2).value = c then
'code
end if
I ask because I need to compare two worksheets and there's about 8 columns
to match and it just seems really cumbersome.
|