ExcelBanter - Variable Not Defined? objPivotCache

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Variable Not Defined? objPivotCache (https://www.excelbanter.com/excel-programming/285473-variable-not-defined-objpivotcache.html)

BEE

Variable Not Defined? objPivotCache

My code:
Set objPivotCache = ActiveWorkbook.PivotCaches.Add
(SourceType:=xlExternal)

Error: Variable Not Defined.

Input welcomed.
B.

BEE

Variable Not Defined? objPivotCache

Oops. Never mind.
Just forgot the
dim pc as pivotcache
Monday, you know.
Thx.
B.

All times are GMT +1. The time now is 05:40 PM.