Excel 2007 pivot table/macro/Runtime error 1004

**abalserv** · 06-01-2010, 04:40 AM

Hi
I have created a macro that works sporadically. Here is the code below. When I try to run it I get

Please Login or Register  to view this content.

This is the actual code of the macro. The debugger points to the last line of it.

Please Login or Register  to view this content.

**Bob Phillips** · 06-01-2010, 04:57 AM

I would guess that the wrong sheet is active, but can you post your workbook for us to check it?

**romperstomper** · 06-01-2010, 06:36 AM

Is cell S20000 actually part of your pivot table?

Re: Excel 2007 pivot table/macro/Runtime error 1004