Pivot table Drilldown has problems with titles with special characters.

[MichaelJohnson]

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.