I have a sheet that has raw data and then a pivot table based on that data and then a graph based on the pivot table.
How can I in vba in excel expand the range of the pre existing pivot table and graph automatically.
I was using this to clear down the data on open and prior to appending the data so I think its the reverse of that ie get used range and use that value for the pivot and graph
With Sheets("CW data")
help would be appreciated hope i explained it ok.
The width of columns remains constant but not the data rows.