jackdandcoke
10-03-2008, 11:49 AM
So I have a long macro that updates a bunch of pivots, when I refresh a pivot table I get the message
Do you want to replace the contests of the destination cells in Quotes?
Is there a line I can add to my macro that will say yes to all of these messages? It's the only error that's keeping me from having this all automated.
Do you want to replace the contests of the destination cells in Quotes?
Is there a line I can add to my macro that will say yes to all of these messages? It's the only error that's keeping me from having this all automated.