I have a workbook with a several pivot tables all based on the data contained
within one sheet of the workbook. Attached to this workbook, i have a macro
that will update the data sheet (the data is pulled from an oracle database).

Within the same macro, i would like to change the range of data each pivot
table is based on because every time the data sheet is updated, more rows of
data are pulled then the last time (i.e. the pivot table was based on
Range("A1:N50") but should now be based on Range("A1:N75"). However, i
cannot seem to figure out how to change this programmatically. Can anybody
help?