Pivot + Macro

[hurriance]

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.

[Dave Peterson]

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