Run-time error 1004 on adding new sheets using unique values

[Phillips Contracting]

I'm trying to set up a macro that will capture all the unique values in a column, and then create a new sheet for each value. What I've got so far technically works, but it's also adding an extraneous sheet (with a generic sheet name, not the specified name I'm giving the sheets) and also giving me "Run-time error '1004': Application-defined or object-defined error" when it runs. I've been Googling like crazy and can't figure out where the error is coming from. I'm guessing it has something to do with naming the sheets, but I'm not sure.

Please Login or Register  to view this content.

I've tried playing with the code so that it only runs while c is not null or not empty, but I keep getting errors no matter what I throw in there. Trying to keep it as simple as possible.

[satabp]

try this

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Which line is highlighted when the error occurs?

Please Login or Register  to view this content.

[Phillips Contracting]

Nothing is highlighted when the error occurs on my code, it just brings up that run-time error.

I changed one thing in your code (Sheet("Sheet1") to ActiveSheet) and it seems to work fine. Thank you so much for your help!