View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Shawn O'Donnell Shawn O'Donnell is offline
external usenet poster
 
Posts: 42
Default compare values in 2 ranges

"Alan Beban" wrote:
you can use

arr1 = Range("M1:M3")
arr2 = Range("CE7:CE9")


True, but then the sort algorithm has to be modified to operate on
two-dimensional arrays.

And if the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to the workbook, then after
the arrays are sorted one can use ColumnsEqual


Looks like some handy stuff. Thanks for the pointer.