Compare Two Rows Directly
 

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

Compare Two Rows Directly
 

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.

--
Regards,
Tom Ogilvy


"Lokesh" wrote:

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

Compare Two Rows Directly
 

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

Tom Ogilvy wrote:
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.