View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rominall Rominall is offline
external usenet poster
 
Posts: 36
Default 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.