Copying text from a cell in the footer and pasting it into a hyperlink address
Dear Graham
Thanks for your help. The document, saved as a macro-enabled document, runs the macro automatically upon opening.
I do, however, get an error when the document opens (see attachment) and I am not sure why. If I ignore the error and click on "End", the document opens and the macro has been run correctly. If I click on "Debug" it takes me to the VBA screen and highlights a line in yellow (see attachment). As the macro appears to be working, is there a way to stop the error appearing? Or perhaps incorporate the clicking of "End" into the macro?
By the way, I have slightly amended you macro code to reflect a change in table cell position and text of the target items.
Kind regards.
Taryn
|