Compare Two Rows Directly

  • Thread starter Thread starter Lokesh
  • Start date Start date
L

Lokesh

Hi,
We need to compare the values in the worksheet row-by-row. But currently
we use cell-by-cell comparison logic. Is there any way to compare two rows
directly without going cell by cell.

Note: We're using Office 2003.

Thanks In Advance,
Lokesh R
 
Not really.

You could always write a function that does the cell by cell for two rows
and then it would look like you were doing it row by row when you passed two
row references to the function.
 
If the functions in the freely downloadable file at
http://home.pacbell.net/beban, then you might use

RowsEqual(Row1, Row2)

Then you can avoid writing such a function yourself; it returns True if
the rows are the same, False if they aren't.

Alan Beban
 
Back
Top