Cache of Pivot table is not selecting the table values PROPERLY
Hi,
I'm trying to create a pivot table , in that Set cacheOfpt = ActiveWorkbook.PivotCaches.Create(xlDatabase, Range("A1:Z" & lRow)) is not set properly , its showing null and also not showing any error at that line.
I've attached my excel with pivot vba code in it.
Attachment | Size |
---|---|
ALLBUCKETS.xls | 886 KB |
Recent comments
5 years 27 weeks ago
6 years 13 weeks ago
6 years 25 weeks ago
6 years 28 weeks ago
6 years 29 weeks ago
6 years 34 weeks ago
6 years 43 weeks ago
6 years 43 weeks ago
6 years 43 weeks ago
6 years 43 weeks ago