Gokul001,
I have 6 sheets in an excel file. Sheets 1 & 2 use Sheet 5 as data source for pivot table, Sheets 3 & 4 use Sheet 6 as data source for pivot table. The range for Sheets 5 and 6 will be dynamic. Need to be able to pass parms to Invoke VBA.
Gokul001,
I have 6 sheets in an excel file. Sheets 1 & 2 use Sheet 5 as data source for pivot table, Sheets 3 & 4 use Sheet 6 as data source for pivot table. The range for Sheets 5 and 6 will be dynamic. Need to be able to pass parms to Invoke VBA.