Set pMod = ActiveSheet.PivotTableWizard failure

yardbyrd

New Member
Joined
Aug 26, 2009
Messages
13
Out of the blue......having used this piece of code in a pivot table creation subroutine for quite some time......."Set pMod = ActiveSheet.PivotTableWizard" throws an error: Run-time error Object variable or With block variable not set" This subroutine worked perfectly fine a month ago. And if try to simply create a pivot table in this workbook using the pivot wizard, Excel crashes. WTH!!!
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Watch MrExcel Video

Forum statistics

Threads
1,099,684
Messages
5,470,120
Members
406,681
Latest member
sachinmasurkar

This Week's Hot Topics

Top