I want to use a worksheetname variable rather than the
hardcoded
worksheetname name, while creating a pivot table...

Please See the code below:

ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatab ase,
SourceData:= _
"Raw_Data!R1C1:R884C59").CreatePivotTable
TableDestination:="",
TableName:= _
"PivotTable5", DefaultVersion:=xlPivotTableVersion10
ActiveSheet.PivotTableWizard
TableDestination:=ActiveSheet.Cells(3, 1)
ActiveSheet.Cells(3, 1).Select
ActiveWorkbook.ShowPivotTableFieldList = True


Instead of raw_data I want to use RAWDATANAME variable....
How to replace
it?

Thanks in advance
monika