macro error when shared
I have a macro-driven workbook which I sent to a client, but when she tries
to run it she gets an error in the initial portion of the macro (as shown
below)...I'm not sure if this is enough info to understand the issue or not.
ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatab ase, SourceData:= _
"TendercardReport!R1C1:R100C49").CreatePivotTa ble
TableDestination:="", _
TableName:="PivotTable10", DefaultVersion:=xlPivotTableVersion10
The macro runs a pivot table from a table of data and then transposes the
vales into another output table.
Appreciate any help or thoughts...
M
|