Compare two ranges of cells and return the value into one of the ranges
Posted by frame on October 16, 2000 6:50 PM
I'm trying to do a comparison between two ranges of cells and I want to return a value into the second range.
My first range1: A1:IS1
My second range2: A2:IS20
I need to compare the value for each row in range2 with the value in range1 and return the value into range2.
My IF condition is like this,
If Range1(cell1) = Range2(cell1) Then Range2(cell1) = 1
If Range1(cell2) = Range2(cell2) then Range2(cell2) = 1
and so on (until end of line).
I've been trying to do this but I didn't able to get it solved. Please help.. I'm new in VBA.