Good work then !
I don't know your setup good enough to suggest how to deal with creation and
deletion of objects. But you can avoid all kinds of "do you really want to
?"-messages by doing

Application.DisplayAlerts = False
' code goes here
Application.DisplayAlerts = True

it means "I know what I do so don't ask".

HTH. Best wishes Harald

"nbaj2k" skrev i
melding ...

It worked perfectly, I didn't know you could do that with Pivot tables.

I have one more question. what I do is have a Macro and make a Pivot
table for the dates on a new worksheet. After I make it I want to take
out all of the headings and everything so it just looks like regular
data. What I have been doing is in the macro selecting the region
after I have it set the way I want then copying and pasting the values
onto another worksheet and deleting the sheet with the Pivot table on
it. It seems like there has to be an easier way. Plus when I delete
the page with the Pivot table on it, even when I automate it, it stops
and asks me to delete the page since there are values in the Pivot
table, I have to click yes everytime. I'm trying to make this process
for someone and I really don't want to have that in there.

If I can change it so I don't have to delete the table that would be
great, or if I can make it so that it does not ask me to confirm
anytime that would be be fine too.

Any ideas?

Thanks a whole lot!

~J


--
nbaj2k
------------------------------------------------------------------------
nbaj2k's Profile:
http://www.excelforum.com/member.php...o&userid=36480
View this thread: http://www.excelforum.com/showthread...hreadid=562821