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

stralia > Microsoft Certified Application (Excel) Specialist > Technical Trainer - Excel and VBA > Author ->www.excelitems.com > 0-40-48-43 > --- > ----- > --- > - > > On Mar

$$Excel-Macros$$ Re: Need Help

I found this example online. It actually refreshed every 15 seconds continuously, but if you press the F12 key, it will stop the refresh (that way you do not have to ^Break the code) http://forums.pcworld.co.nz/showthread.php?t=54801 On Feb 28, 2:17 am, himu wrote: > Hi All, > > I am trying

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

I have recorded a macro using Excel 2007 macro recorder. This macro selects a certain range, and then creates and places a Pivot Table on a different sheet. I figured using record it would work, but with out any changes to the macro, I get a Runtime Error 5 (Invalid Procedure or Argument). I shou