error karena tidak ada sheetname "Test Outbound"
seharusnya
ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _
"'out'!R8C1:R1976C7").CreatePivotTable TableDestination:="", _
TableName:="PivotTable1", DefaultVersion:=xlPivotTableVersion10
2009/3/27, Zigen X <[email protected]>:
> Hi Semua,
>
> i ada sedikit problem dgn macro...
> i dah record macro dlm satu sheet and then bila i buat pivot table daripada
> sheet yg sama ke sheet yg lain..ada error message pula...tolong ya... and
> thanks in advance..
>
> Thanks
> Zigen..
>
>
> New Email names for you!
> Get the Email name you've always wanted on the new @ymail and
> @rocketmail.
> Hurry before someone else does!
> http://mail.promotions.yahoo.com/newdomains/sg/
