Create pivot table using vba

[pdileep382]

Hi,

I have the data in which 3 to 4 columns are text columns with cells containing more than 255 characters.
When I am trying to create the pivot cache using the following vba code. I am getting an error of Type mismatch.
but when I delete the cells which contains more than 255 characters It is working fine.

Vba code I am using to create pivotcache is
Set Pc = ActiveWorkbook.PivotCaches.Add(xlDatabase, Range("A1:AB784"))

I am using Excel 2013


Can you please help me resolve this issue.

Thanks in advance

Regards,
Dileep