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
> 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
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.
'--