Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Select pivot field not working

Status
Not open for further replies.
gcole

gcole

Programmer
Aug 2, 2000
390
US
I am trying to select a value in a pivot table with the following code:

ActiveSheet.PivotTables("PivotTable1").PivotFields("Date").CurrentPage = _
"07/03/2002"

As I step through the code, the cell is selected but the update is not made. Any ideas?
Thanks
 
Sort by date Sort by votes
Does anyone have the answer to this one?
 
Upvote 0 Downvote
maybe....?



ActiveSheet.PivotTables("PivotTable1").PivotFields("Date").CurrentPage = _
datevalue("07/03/2002")
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

M
  • Locked
  • Question
Reference Pivot Tables by name 1
Replies
2
Views
588
mintjulep
M
remeng
  • Locked
  • Solved
Combine two working macros into one for MS Word 1
Replies
7
Views
858
strongm
strongm
arvarr
  • Locked
  • Question
Variable in Pivot Table 1
Replies
4
Views
229
arvarr
arvarr
morechocolate
  • Locked
  • Question
run-tune error 3704 operation is not allowed when the object is codes: I don't think so.
Replies
7
Views
933
morechocolate
morechocolate
arvarr
  • Locked
  • Question
Pivot Table drill through in a new workbook
Replies
3
Views
302
arvarr
arvarr

Part and Inventory Search

Sponsor

Back
Top