Sort Page Field With VBA

Hi all,

I have several pivot table templates built, and had to add in additional items to the page field. They are now out of order (they need to be alphabetical). If I was starting from scratch, I would just pull the pagefield down, sort it, and add it back to the top. However, since the entire page is built with formulas and formatting and such, I need to use code.

SO! Here's what I have so far:

Please Login or Register  to view this content.

The problem with this code is that is sorts all pivot fields, and I need it to just sort "Geographies." There is 1 "Geographies" pf per sheet and there are number of sheets in the workbook. I can't figured out how to make the pf specific to "Geographies." Hopefully this makes sense - any help would be appreciated!!

Thanks,
Jill