jpx wrote:
I have named two ranges of cells and I want to compare one range to
another to see if they are identicle. I tried =exact(range1,range2)
but get an error. Can this be done?


If the functions in the freely downloadable file at
http://home.pacbell.net/beban are available to your workbook,

=RowsEqual(range1,range2) will return True or False.

Alan Beban