Hi Guys,

I have fixed the problem. I specified "[WorkBook1]dec!R1C1:R179C20" and it
worked. I am not sure why the PivotCaches.Add method is not taking a Range
object for the SourceData argument. Though the help says that a Range object
could be passed.

Cheers,
Vijay

"chubster264" wrote:


A number of Pivot Table functions are not available in Excel 2000 VBA -
introduced in 2002 iirc


--
chubster264
------------------------------------------------------------------------
chubster264's Profile: http://www.excelforum.com/member.php...o&userid=30164
View this thread: http://www.excelforum.com/showthread...hreadid=509998