identifying PivotTables
 

Running a macro and updating maybe 30 pivot tables, I get an error message
and the debugger indicates the Pivot Table number but I do not know how to
identify which is the Pivot Table where the macro is stumbling on. Any ideeas?
Thank you for your help

identifying PivotTables
 

Activesheet.PivotTables(i).Name

where i is the number you speak of and is an index into the pivottables
collect for that sheet.

Just a guess of course since you description of very vague as to what the
number you have actually is.

--
Regards,
Tom Ogilvy


"Gaby" wrote:

Running a macro and updating maybe 30 pivot tables, I get an error message
and the debugger indicates the Pivot Table number but I do not know how to
identify which is the Pivot Table where the macro is stumbling on. Any ideeas?
Thank you for your help