Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / May 2008

Tip: Looking for answers? Try searching our database.

Cycling Through Page Fields

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
T. Jenkins - 29 May 2008 19:56 GMT
I have a routine that cycles through page fields in a pivot table using VB
code.  For the most part, things work fine, but every now and then, I have an
item in my list that doesn't exist in the data generating the pivot table.  
The code is generating some errors as a result, I think because it's
overwriting the previous item in the page field list with the one I'm trying
to look at.

Is there an error check step that would help me avoid this?  I just want to
code to skip this item if it doesn't exist in the Pivot Table.

Thanks,
Todd
Debra Dalgleish - 30 May 2008 04:47 GMT
There's sample code here that will check for each item before changing
the page field:

  http://www.contextures.com/xlPivot09.html

Under the heading 'Check for Pivot Items Before Printing'

> I have a routine that cycles through page fields in a pivot table using VB
> code.  For the most part, things work fine, but every now and then, I have an
[quoted text clipped - 8 lines]
> Thanks,
> Todd

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.