Greetings, All,

I'm doing gross arithmetic functions on various pivot table results. The
pivot table is Access-driven, and the target cells move around, based on the
query results.

I want to ensure that if a column or row drops out, or, conversely, if rows
are columns are added by the query, the calculations "follow" the target
cells.

I believe this can be accomplished by the "$" in the cell designator, but I
want to ensure I'm using it properly.

Regards,

You probably want the GetPivotData function. You can look it up in help and
here is an additional resource...

http://www.contextures.com/xlPivot06.html
--
HTH...

Jim Thomlinson


"Merlyn" wrote:

Greetings, All,

I'm doing gross arithmetic functions on various pivot table results. The
pivot table is Access-driven, and the target cells move around, based on the
query results.

I want to ensure that if a column or row drops out, or, conversely, if rows
are columns are added by the query, the calculations "follow" the target
cells.

I believe this can be accomplished by the "$" in the cell designator, but I
want to ensure I'm using it properly.

Regards,