I am working on a document that has front matter, a main body of content, and a number of appendices. I have used Word's hierarchical numbering system to create the headings with (Heading 6) used to create the appendix level 1s.
I need to select the first instance of a heading 6 so that I can use its page number to manipulate the overall page numbering.
The overall document numbering is formatted as 'Page n of nn' with the front matter in Roman numerals, the main body in Arabic numerals, and no numbering in the appendix section. I need (1) to work out the number of the last page before the appendices and (2) to stop the numbering being inserted into the footers of the appendices section. I think I can do (1) and (2) if I could select Appendix A.

PS I'm an absolute newbie at VBA so apologies beforehand if this is so simple you're all surprised I had to ask.