Neeraj Kumar
06-04-2010, 11:48 PM
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
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