Pivot tables in a macro

Giganews Newsgroups
Subject: Pivot tables in a macro
Posted by:  Mark Vella (mar…@abcfinancial.com)
Date: Thu, 2 Oct 2003

I am running a macro that includes a pivot table and
chart, when I run the macro my table comes out OK, but I
get a VB popup "runtime error 9".  If I click end, apply
a data source to the correct axis in the chart, I am
fine.  HOW DO I GET THE MACRO TO RUN WITHOUT HAVING TO DO
THAT????

Replies