I don't have any more guesses. Maybe someone will jump in with something
useful!

wrote:

Both lists are values, either text or general format - I've tried both

On Fri, 13 May 2005 10:01:27 -0500, Dave Peterson
wrote:

Are both lists values or formulas?

if they're simple formulas that point to another sheet, then sorting that won't
work.

wrote:

One further note:

The data are real estate parcel numbers. If:
i is the row of a parcel number in Sheet1, and
j is the row of the same parcel number in Sheet2
(i and j are not the same due to the sorting problem)
then:
Range("Sheet1!A" ? i)=Range("Sheet2!A" ? j) is TRUE
in every case, yet the sort order is different!

--

Dave Peterson