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

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Watch MrExcel Video

Forum statistics

Threads
1,102,291
Messages
5,485,975
Members
407,523
Latest member
Talicius

This Week's Hot Topics

Top