Hyperlink File Path Changes. Hair loss imminent.
I guess we need to see what H.Address is.
Put a
Debug.Print H.Address
before the H.Address =... line and see what it shows in the debug
window.
If that doesn't give you any clues, post what it gives you in your
reply here and I will see if it gives me any.
Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
|