Hi Ujjwal,
I think I have a solution for your problem.
But how can I attach files???
Regards,
Sergio
On 19 Apr., 11:38, Ujjwal Jha wrote:
> Attached is the file on which macro was created and used.
>
>
>
>
>
> On Sun, Apr 19, 2009 at 2:52 PM, Ujjwal Jha wrote:
> > Please find below the macro
Please find below the macro recorded:
Sub Trial()
'
' Trial Macro
'
'
'
Range("A1:F16").Select
ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _
"Sheet1!R1C1:R16C6").CreatePivotTable TableDestination:="",
TableName:= _
"PivotTable1", DefaultVersion:=xlPi
Attached is the file on which macro was created and used.
On Sun, Apr 19, 2009 at 2:52 PM, Ujjwal Jha wrote:
> Please find below the macro recorded:
>
> Sub Trial()
> '
> ' Trial Macro
> '
> '
> '
> Range("A1:F16").Select
> ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceDat
Hi Ujjwal,
Yes, you were able to make us understand. and the problem is Macro
recorder is not enough intelligent to create loops for us.
Now to better understand the problem, please post what you've recorded
through macro.
For more tips, tricks, downloads and problem solutions: visit -->
http://
