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.

--
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

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.
>