find duplicate range , position range

hello friends ,

i try to find solution , but wasn't able to find

i have two sheets , one with IDS another with POSITION ,

with IDS sheet i have many ids fill till A2:J3721

in ids sheet i have range A2:A25 , A26:A49 and so on till A3721

is it possible to find duplicate range of A2:A25 in entire sheet ....

and to name those range of duplicate range in position sheet .

and so on after A2:A25 and so on ,

for better understanding i have attach sample file . SAMPLE FILE1.xlsx

also if possible can we color all duplicates range with unique color ..

Please Login or Register  to view this content.

hello frds how i can use above code with
"A1:A24"
"A25:A48"
"A49:A72"
"A73:A96"
"A97:A120"
"A121:A144"
"A145:A168"
ranges ....till A54001
difference between range is 23 cells .

sir , i am looking for duplicate range of a2:a25 in entire sheet ,

Set rData = Range("A1:X54001")

i am unable , to loop every next 23 range of cells to find in entire sheet .

right now i have to entry this ranges manually .

"A1:A24"
"A25:A48"
"A49:A72"
"A73:A96"
"A97:A120"
"A121:A144"
"A145:A168"
ranges ....till A54001