Pivot table Drilldown has problems with titles with special characters.

MichaelJohnson

New Member
Joined
Apr 22, 2019
Messages
2
MrExcel I have been working with using your Pivot table drilldown vba code (Thank you for it!) but I have found that any titles with a special character i.e #, can not be formatted or hidden. I see in your code the section "For Each rCell In rFieldFormats. Resize(, 1)" that I think maybe removing special characters but I am not sure how to use it or if it removing characters. Is there a solution for handling the special characters in your drill down code titles rather than removing characters?

I am new to posting so if I have broken some rules my apologies.
 

Forum statistics

Threads
1,086,244
Messages
5,388,669
Members
402,134
Latest member
McKnze21

Some videos you may like

This Week's Hot Topics

Top