macro not finishing task

this macro works perfect, but does not finish creating??

If a c is in col O macro should create a new sheet.
If P is col O it prints.

The only problem is when I try to create a big list. It doesn't finish.
Any Ideas.

Hello erock24,

How big of list are you referring to? What error message and number to you get or does the program freeze?

Thanks,
Leith Ross

See if this works for you:

Please Login or Register  to view this content.

I edited code with your change, it works but I loose my print options.
I need to have those new sheets print to 1 page.
I added code I thought would do it but it doesn't. What have I done wrong??

Please Login or Register  to view this content.

How big of list are you referring to? What error message and number to you get or does the program freeze?

It doesn't freeze it just doesn't produce all the sheets it should.

Ikaabod's edit fixed that problem, but now I have a print set up issue. i guess since the copy method is different. I don't really know why Ikaabod's edit works.

And that's amazing.

Works perfectly Thank you very much for your time and help.

You're quite welcome. I'm glad I was able to help.

All the best,
Ik