Garry,

Thanks - you are correct about the snippets - I posted only as much as I thought was required.

NewSheet is always created from scratch after first testing for that sheet's existence (and deleting it if it exists) . I normally don't activate an object if I've defined it - you are correct that there's no need to do so as you can reference it, its methods and procedures, directly.

You answered my question about used range.columns - thanks

I hadn't thought to use arrays when I originally wrote the routine as my comparison sheets were very small However, they've now become much larger, so I'll put your code into mine (and credit you in the header block!).

By the way, I am unfamiliar with using the ampersand ('&') for variable typing. Is this a shortcut for integer?

Art