Guest_imported
New member
- Jan 1, 1970
- 0
I'm doing a macro that build a pivottable and some other actions, but my problem is that I need to use variables that represents ranges into pivottable code,I can't find the sintax or I don't know if that kind of things can make it.
sample:
ActiveSheet.PivotTableWizard SourceType:=xlDatabase, SourceData:= _
"'release'!R1C3:R983C6", TableDestination:="R3C10", TableName:= _
"PivotTable1"
R1C3:R983C6
Here is the part that I want to use variables.
sample:
ActiveSheet.PivotTableWizard SourceType:=xlDatabase, SourceData:= _
"'release'!R1C3:R983C6", TableDestination:="R3C10", TableName:= _
"PivotTable1"
R1C3:R983C6
Here is the part that I want to use variables.