Creat Pivot table by VBA

[Neeraj Kumar]

Hi Dear,
Please Help!
I am biginner in VBA, I have a data, I want to filter the data from master sheet using user form and when click on submit button then filter data show from “A16 to Last Row and create a pivot table show in cell “A3”. This pivot table is based on below advanced filterd data.

Error Showed on :
Set PT = PTCACHE.CreatePivotTable(TABLEDESTINATION:=WSD.Cells(3, 1), TABLENAME:="PIVOTETABLE1")

Run-Time error ‘1004’
The PivotTable name is not valid. To Create a Pivot table Report,
You must use data that is organised as a list with labled columns. if
you are changing the name of pivot table field, you must type a new
name for the filed.


With Reagrsd & Thanks
Neeraj Kumar Singh
Contact No. 9540567486
E-Mail : deleted

[Bob Phillips]

Can you post your workbook, it is a bit difficult without the data.