Find Entire Range

[Journeyman3000]

Hi all,

I am wondering if there is a method to select an entire range then find the full contents of that range within another sheet, and return the row number.

For example:

Please Login or Register  to view this content.

I know this method doesn't work like this, but hopefully you get the idea.

I'm looping through each row in one sheet and looking for that exact same row in another sheet. A typical find method is only ever finding the first instance of cell (when I use it correcrtly), and its throwing up duplicates where there shouldn't be.

I hope this is understandable.

Cheers

[:) Sixthsense :)]

May be something like this...

Please Login or Register  to view this content.

But I don't know what you are trying to do after the first match

[Journeyman3000]

Thanks for your assistance.

I have thousands of rows in sheet one. and thousands of rows in sheet two. I need to look at each row range in sheet one and locate that exact same row range in sheet two, which could be anywhere.

I tried this code, but it's not there for me. The r.value is not the entire range but the first cell in the range. I need to compare the full range.