04 Compare - AndrewMB2/Logic-Architect-for-Excel-VBA GitHub Wiki

Compare method

Compares two rows for the given columns. Returns True if they match, otherwise False.

Applies to

TableData ArrData RsetData Xdata XShared

Parameters

Name Type Description
Row1 Long First row to compare.
Row2 Long Second row to compare.
Headers Value, array or ParamArray Field or fields to be compared.

Compare returns True if the data in the two rows for the specified fields has the same data type and value. If no fields are specified, compares all fields.