Pivot Table Not Selecting Max Week

[rbirch]

I'm trying to write some code where it will select the max pivot item in "Workweek". However, I can't get it to quite work right. Thanks for your help.

Please Login or Register  to view this content.

[oeldere]

Do you mean this solution?

[rbirch]

No, in the workbook you posted. I would want workweek 26.2 be the only selection. The logic stops at workweek 25, I wonder why that is.

[oeldere]

with the pivot table in the green cells.

[rbirch]

This is close to what I want...the code breaks when I try to turn on lngMaxValue in the pivot table. I bolded the area where teh code breaks down.

Please Login or Register  to view this content.