Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to put variables in a pivottable code with a macro

Status
Not open for further replies.

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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top