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
Why is there an ellipsis after Selection?
Remember what the dormouse said
Feed your head
Because it doesn't work otherwise. Especially since I add a destination, name and default version after that.Originally Posted by romperstomper
Please Login or Register to view this content.
Disregard the equations, they are just a simple way of shifting tables.
------
Problem solved - adding .Address after Selection fixed things.
Last edited by Newbie_Nick; 10-19-2010 at 11:02 AM. Reason: Problem Solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks