Variable Not Defined? objPivotCache

B

BEE

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

Error: Variable Not Defined.

Input welcomed.
B.
 
Top