| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace worksheet name with a variable
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replace a fixed number with a variable via popup | Excel Worksheet Functions | |||
| Need to replace one dynamic variable with another dynamic variable | Excel Worksheet Functions | |||
| Looking up a variable in one worksheet and copying information from another column to another worksheet?? | Excel Discussion (Misc queries) | |||
| 3 variable find and replace | Excel Discussion (Misc queries) | |||
| Replace variable row number in formulas | Excel Discussion (Misc queries) | |||
Threaded Mode
