Mine didn't loop, but the screen vibrated. haha
Sharron
--- On Wed, 5/25/11, dmgathmann <dmgathmann@yahoo.com> wrote:
From: dmgathmann <dmgathmann@yahoo.com>
Subject: [ExcelVBA] Re: Refreshing Pivot Tables
To: ExcelVBA@yahoogroups.com
Date: Wednesday, May 25, 2011, 1:23 PM
I tried the worksheet change event first, but that one line of code appeared to cause an endless loop for some reason.
Dave Gathmann
--- In ExcelVBA@yahoogroups.com, "david braithwaite" <dbraithwaite@...> wrote:
>
> On using worksheet change event.
>
> If you made sure that change was in your data source --- otherwise exit
> without recalculating
>
>
>
> Db
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
[Non-text portions of this message have been removed]
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar