J
jh
I am trying to write a function to ascertain if a worksheet solely
contains a pivot table based on information from elsewhere in that
workbook, E.g. a worksheet containing data formula would return False,
A worksheet containg data and a pivot would return false, a worksheet
containing a pivot of external data would return false, but a
worksheet containing a pivot of data within the workbook would return
true. I'm not sure of any direct way to do this, but am thinking on
the lines if the used range of the sheet matched the range used by the
pivot and the source data did not reference another file that would
give me the correct result, however I can't find any properties for a
PivotTable object. I get as far as wks.PivotTables(1). then help
runs out of help! Could anyone point me in the right direction please?
Thanks J. (Win7/Excel 2007)
contains a pivot table based on information from elsewhere in that
workbook, E.g. a worksheet containing data formula would return False,
A worksheet containg data and a pivot would return false, a worksheet
containing a pivot of external data would return false, but a
worksheet containing a pivot of data within the workbook would return
true. I'm not sure of any direct way to do this, but am thinking on
the lines if the used range of the sheet matched the range used by the
pivot and the source data did not reference another file that would
give me the correct result, however I can't find any properties for a
PivotTable object. I get as far as wks.PivotTables(1). then help
runs out of help! Could anyone point me in the right direction please?
Thanks J. (Win7/Excel 2007)