Runtime error 438 - on its own code!

[corquando]

Howdy, folks.

Here's a troubling snippet:

ActiveSheet.PivotTables("PivotTable1").SubtotalLocation = xlAtBottom

I'll post more/previous if need be . . . but this little line throws an error that says

Run-time error '438':

Object doesn't support this property or method.

The trouble is that the code was written in the macro editor by the application itself while recording the PivotTable Options.

I did not know that Excel could write its own bad code. I'm great at that, but I never thought I'd see this eventuality.

Anyway - any ideas?

Thanks in advance, as always.

 

[Andrew Poulsom]

That method was introduced in Excel 2007. Are you trying to use it in an earlier version?