LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 14
Default On Error Resume Next TROUBLE

Hi to All,

I have an application that runs well on my Win98 / Excel
2002 setup, but fails on my WinXP / Excel 2002 setup using
the same file. The failure point is after an On Error
Resume Next line as follows:

On Error Resume Next
With pvtTable1.PivotFields("Absence")
.PivotItems("0").Visible = False <-- FAILS HERE
.PivotItems("").Visible = False
.PivotItems("(blank)").Visible = False
End With
On Error GoTo 0

The Error Message is:
Runtime Error 1004
Unable to get the PivotItems property of the PivotField
class.

It seems as though the On Error Resume Next is not
functioning on my WinXP / Excel 2002 setup. Yet I've
gone through Excel's Detect and Repair and I've confirmed
that I have the latest Office XP update from Microsoft's
web site on this machine.

Has anyone else observed this?

Best Regards,
Walt
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
On error resume next not working cluckers Excel Discussion (Misc queries) 3 November 25th 09 08:12 PM
On error resume next problem freekrill Excel Discussion (Misc queries) 2 December 7th 05 12:51 AM
ON ERROR RESUME NEXT D.S.[_3_] Excel Programming 7 December 1st 03 09:40 AM
On Error Resume Next D.S.[_3_] Excel Programming 1 November 28th 03 04:52 PM
On Error Resume Next Mike[_58_] Excel Programming 3 November 23rd 03 05:09 PM


All times are GMT +1. The time now is 07:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"