Thread: Variable Not Defined? objPivotCache
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BEE BEE is offline
external usenet poster
  
Posts: 10
Default Variable Not Defined? objPivotCache
My code:
Set objPivotCache = ActiveWorkbook.PivotCaches.Add
(SourceType:=xlExternal)

Error: Variable Not Defined.

Input welcomed.
B.
Reply With QuoteReply With Quote