Copy Table is not working for filtered data in macro and manually
I am writing a macro that exports my pivot table to Excel by copying it and pasting it into a new Excel sheet. When I run the Macro it works on all instances I need, however 1 specific filter causes the macro to fail at the CopyTableToClipboard function without giving an error message as to why. When I right click and copy the Table Data Area and try pasting it in excel manually, it does not work either for this specific filter.
If I use CopyBitmapToClipboard or the built in send to excel option, both work perfectly fine but for some reason copy table does not.