I use VBA code to copy a pivot table and then past it using the paste special 'values' option. Even although I use Application.CutCopyMode = False,
the clipboard is not cleared. Because there are 20 pivot tables that must be copied and pasted, the clipboard becomes overloaded.
Is there any other way to clear the Windows clipboard totally from within the macros?
Can anyone out there help me, please.