Error when creating pivot table based on user date range selection

[BG1983]

Hi, I am getting the error: Run-time error '5' - Invalid procedure call or argument

at the line: ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:="WOF" _
, Version:=6).CreatePivotTable TableDestination:="Who's On 1st!R2C1", _
TableName:="PivotTable3", DefaultVersion:=6

of the following code.. Whats happening is on the sheet "FLHearingsMaster" there is a table.. and there is a button to run the macro WOF - Which prompts the user for a start date and then a finish date... it filters the table (Table_FLHearings) by the date range.. (dates are in table column 6) and then moved that data to another sheet named "Who's on 1st Data" where it creates a table named "WOF" then, and this is where its causing the error, I want it to insert the pivot table, based on the table "WOF"...

does anyone know what I am doing wrong here by chance?

Please Login or Register  to view this content.

[BG1983]

I was able to figure this out.