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: 4
Default RunTime Error 1004? _Default Property?

Hi All,

I'm writing some code that automatically changes PageField Values in a
PivotTable. On one of them, I get a Run Time Error 1004 "Unable to set the
_Default property of the PivotItem Class".

Does anyone know what this means in this context? Below is a section of code
that I'm using, and it works ok on another field that I am doing it on...

ActiveSheet.PivotTables("PivotTable1").PivotFields ("Wk_Ending").CurrentPage
= _
"07/07/2007"
 
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
Runtime Error 1004 Unable to set the top property of the picture c JB Bates[_2_] Excel Discussion (Misc queries) 1 March 3rd 10 08:04 PM
Hiding Rows Error - "Runtime Error 1004 - Unable to set the hidden property of the range class" Punsterr Excel Programming 2 April 9th 07 05:32 PM
Runtime Error 1004 Unable to set the XValues property of series cl Rachel Excel Programming 2 April 26th 06 02:41 PM
Runtime error 1004 - unable to set Visible property of Worksheet c SueJB Excel Programming 2 October 4th 05 02:27 PM
Runtime 1004 unable to get find property of range class Eric Excel Programming 2 January 30th 04 01:06 PM


All times are GMT +1. The time now is 02:57 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"