why can't I setup a macro to run Pivot Table?

I am trying to record a new macro to run Pivot Table. But whenever I run that macro, it pops up a "debug" window.

Can anyone instruct me how to do that?

Thanks a million!

If you click the Debug button, what row is highlighted in the recorded code?

chrisdtran wrote:
> I am trying to record a new macro to run Pivot Table. But whenever I run
> that macro, it pops up a "debug" window.
>
> Can anyone instruct me how to do that?
>
> Thanks a million!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html