$$Excel-Macros$$ HELP! Pivot Table Keeps Calculating!

2009-02-18 Thread TimoHubbard
I am running this code on a pivot table to reselect all the items that I have previously unselected. It is taking too long to run because it is updating the pivot table each time. It says "Calculating PivotTable". Is there any way to pause the calculations of a pivot table? With Worksheets

$$Excel-Macros$$ Re: Overflow Error From MsgBox

2009-02-13 Thread TimoHubbard
> Regards, > Akhilesh Kumar Karna > > > > On Thu, Feb 5, 2009 at 12:40 AM, TimoHubbard wrote: > > > Can anyone help me with this code block?  I am getting an 'overflow' > > error when I run this code.  Can someone help me determine where the > > overf

$$Excel-Macros$$ Overflow Error From MsgBox

2009-02-04 Thread TimoHubbard
Can anyone help me with this code block? I am getting an 'overflow' error when I run this code. Can someone help me determine where the overflow is occuring? Is it the text that I put into the MsgBox? I'm running Excel 2000. '--