Taryn
Is there a point to having a hyperlink in a footer when it isn't clickable unless you edit the footer? In my opinion a hyperlink in a footer is really only useful if you are exporting the doc to PDF.
We would do this with ranges rather than selections. Can you post a sample document which doesn't need any body content but will need to contain the footer you want to work on.
You will also need to identify which 6 digits you want to replace. Your recorded code shows three separate numbers in the hyperlink path but none of them have six digits.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia