Pivot tables in a macro

  • Thread starter Thread starter Mark Vella
  • Start date Start date
M

Mark Vella

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????
 
That looks like a "subscript out of range" error. Best thing to do is debug
the code when the error happens, and find out exactly what the problem is.

You might try posting the offending line here (or even better, in
microsoft.public.excel.programming) to see if the error is obvious. If not,
perhaps the whole routine, or the relevant portion, would be needed.
--
HTH -

-Frank Isaacs
Dolphin Technology Corp.
http://vbapro.com
 
Back
Top