Compare Two Rows Directly

[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

 

[Tom Ogilvy]

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.

 

[Alan Beban]

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