$$Excel-Macros$$ Re: PivotTable VBA Macro Assistance Requested - Error 5

2009-03-06 Thread ccraiff
Sorry Ashish. Step 1 did not fix the issue, I still get the same Error. On Mar 5, 9:24 pm, Ashish Jain <26may.1...@gmail.com> wrote: > Hi ccraif, > > Some check points for you, please try and revert back to us. > > 1. Try this(below) - Focus on _ (Underscore) in the end preceded by a > spacebar.

$$Excel-Macros$$ Re: PivotTable VBA Macro Assistance Requested - Error 5

2009-03-05 Thread Ashish Jain
Hi ccraif, Some check points for you, please try and revert back to us. 1. Try this(below) - Focus on _ (Underscore) in the end preceded by a spacebar. ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _ "B3 Production Input!R1C1:R111C7", Version:=xlPivotTableVersion12). _