Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating PivotTable in Macro
I have recorded a macro to create a PivotTable, and I can get it to run
successfully on my PC. But when a user on another PC tries it, they get "Run-time error '1004': Application-defined or object-defined error. When I go to debug, the entire portion of the below code beginning with "ActiveWorkbook" is highlighted as the source of the problem. Does anyone have any idea as to why this might happen? Thanks for your help! Range("A1").Select Dim endRow As Long endRow = Cells(Rows.Count, 1).End(xlUp).Row Range("K2").Select ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatab ase, SourceData:= _ "'Projects Detail & GL Accounts'!R1C1:R" & (endRow + 1) & "C16").CreatePivotTable _ TableDestination:="", TableName:="PivotTable1", DefaultVersion:= _ xlPivotTableVersion10 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a PivotTable w/o selecting data in an existing PivotTable | Excel Discussion (Misc queries) | |||
Creating a PivotTable in VBA | Excel Programming | |||
Creating a PivotTable with VBA | Excel Programming | |||
Type Mismatch when creating a pivottable macro | Excel Programming | |||
Creating a database and PivotTable with a Macro | Excel Programming |