Pivot + Macro
 

I want to write a macro to generate a pivot table from
a data source. However, after I record the macro, I find
that it cannot run porperly when the dimension of the
data source is changed.
Please help me to solve this problem. Thanks.


--
hurriance
------------------------------------------------------------------------
hurriance's Profile: http://www.excelforum.com/member.php...o&userid=30882
View this thread: http://www.excelforum.com/showthread...hreadid=519645

Pivot + Macro
 

Maybe you can use a dynamic range name to point at your data:

See Debra Dalgeish's site for some nice tips:
http://contextures.com/xlNames01.html#Dynamic



hurriance wrote:

I want to write a macro to generate a pivot table from
a data source. However, after I record the macro, I find
that it cannot run porperly when the dimension of the
data source is changed.
Please help me to solve this problem. Thanks.

--
hurriance
------------------------------------------------------------------------
hurriance's Profile: http://www.excelforum.com/member.php...o&userid=30882
View this thread: http://www.excelforum.com/showthread...hreadid=519645

--

Dave Peterson