VBA Max Workweek

[rbirch]

My question is why does my code crap out on finding the max and leaves 18, 19 and 20 selected in the attached PNG for Workweek"? Does Excel have max or min of Pivot Items it can select?

I tried using the macro I have on a fresh copy of Excel to get rid of any behind the scene errors.

This is the code I use albeit very shorten.

Thanks for your help.

Please Login or Register  to view this content.