| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run-time error '5':Invalid Procedure call or argument
I'm attempting to write VBA code for a pivot table range selection, this
expression works when SourceData is set to a fixed range, but when set to the varaible range selection as noted below I receive the subject error message ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatab ase, SourceData:= _ Sheets("Sheet1").Range(Cells(1, 1), Cells(i,5))).CreatePivotTable _ TableDestination:="", _ TableName:="PivotTable9" Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| call procedure problem | Excel Discussion (Misc queries) | |||
| Run-time error '5': Invalid procdre call or argumnt - End/Debug/He | Excel Discussion (Misc queries) | |||
| Invalid outside procedure (creating a PDF button as a macro) | Excel Worksheet Functions | |||
| Run-time Error '5' - Invalid procedure call or argument | Excel Discussion (Misc queries) | |||
| Run-time error '5': Invalid Procedure Call or Argument | Excel Discussion (Misc queries) | |||
Threaded Mode
