Range setting for pivot table
Just want to know the way to set the range property for creating pivot table
provide that the number of row will change by each time.
Eg. The following line R137, today may be 137 total number of row & may be
237 for tomorrow report.
If I just amend the range from R137 to R10000 (aim to cover all data), error
will appear when running the macro if the number of row changed by next time.
Selection.CurrentRegion.Select
ActiveWorkbook.Names.Add Name:="rangeT",
RefersToR1C1:="=aging_data!R11C1:R137C16"
--
aw
|