Selecting, not overwriting, pivot field items

Glory

Well-known Member
Joined
Mar 16, 2011
Messages
640
Recording myself selecting a pivot field item gives "currentpage =".

But when I run that code, if the text I'm inputting is not in the pivotfield's collection, the currentpage just gets overwritten.

Is there a way to select, not overwrite, a pivotfield item?
 

Some videos you may like

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Watch MrExcel Video

Forum statistics

Threads
1,108,954
Messages
5,525,879
Members
409,669
Latest member
JDCupps

This Week's Hot Topics

Top