Store consecutive cells range

Hi everyone,

I'm having trouble coming up with a macro that will loop through a selected column to check for consecutive occurrences and store their ranges.

Here's what i mean:

If the column C has the numbers

C1 - 2
C2 - 2
C3 - 2
C4 - 3
C5 - 3

the macro will store the range C1:C3 and C4:C5, maybe in a array.

Any help would be appreciated.

Hi fgg,
try

Please Login or Register  to view this content.

This is an option to store Each Duplicate range as a range variable

Please Login or Register  to view this content.

Regards Mick

Thank you for all your options.
Let me digest all this code and i'll get post back the results.