Application.DisplayAlerts = False
Activesheet.Delete ' or sheets.Delete
Application.DisplayAlerts = True
--
Regards,
Tom Ogilvy
"Randy" wrote in message
...
Hi,
i realize this is a lame VB question, but I can't find
the way to force the sheets.delete function to skip
the "are you sure" dialog box. Basically, I want a
function at the start of my pivot table macro to do a "if
exist, then delete; else create"
Any code snippets out there that do this?
thanks,
Randy