Error with this code, what's wrong?

[scottintexas]

This keeps generating error 91, Object vVariable or with block variable not set, at the Set line. Since I am not using a with block it has to be the object variable, but I can't figure out what I am missing.

Please Login or Register  to view this content.

Thanks again.

[StephenR]

You don't appear to be setting up AutoFilter. Advanced Filter is a different animal.

[scottintexas]

OK, so how do I do the advanced filter then set a range to the results? I did try changing autofilter to advanced filter and got an error say that it didn't support that method.

I need to read the results of the unique filter. The only way to get a unique list that I know of is to use the advanced filter. Now Excel 2007 help files just plain suck, so there may be something in help to answer my question, but it is eluding me.

[StephenR]

I think you'd be better off copying to another location and then setting the range variable to that location.

[mikerickson]

Please Login or Register  to view this content.

[scottintexas]

Thanks Mikerickson! So simple. However the loop is running away. It seems that xlCellTypeVisible is a never ending list. When the loop finally finishes I'll modify it to stop and just do a "For Next" instead of a "For Each".

Thanks again for your help.