Hi all,
I wrote a simple macro for creating multiple pivot tables in Excel 2003. When I run it on an older machine with Excel 2002 I get a Runtime error 1004 because of this dynamic reference, although data has been selected.
Now if I replace SourceData = Selection with the static "'Sheet1'!R1C1:R51C4" it works. Anyone know how I can avoid this issue and still use a dynamic selection for my pivot tables?Please Login or Register to view this content.
Thanks
Nick
Bookmarks