Excel 2007 : Loop Through Advanced Filter Unique Records

Hey Wrecking_Crew,

I haven't tested it but it should be something like:

Please Login or Register  to view this content.

Let me know if this is what your looking for or if you have any questions etc.

Hope this helps,

Robert Specian Jr.

If this helps, please bump my reputation by hitting the scale in the top right of my post.

Thanks R Specian Jr & Mrice - both with the same code at the same time

Unfortunately gives an error

"Method 'Range of object' _Worksheet' failed

Hey Wrecking_Crew,

Yeah, its pretty funny we posted at nearly the same time = P.

His code has an error in it. The period should be a comma. Try:

Please Login or Register  to view this content.

Hope this helps,

Robert Specian Jr.

If this helps, please bump my reputation by hitting the scale in the top right of my post.

Excellent!!! Works like a charm.