Changing the Hyperlink in a cell

[Michael Kintner]

How can I set or change the hard hyperlink in a cell? I can do it
mannually though Insert Hyperlink, but how can I do it via programming
function?

Thank you in advance for anything.
Mike

 

[Tom Ogilvy]

Turn on the macro recorder while you do it manually, then look at the code.
It will give you the syntax you need.

 

[Michael Kintner]

Thank Tom!! (smile)

Turn on the macro recorder while you do it manually, then look at the code.
It will give you the syntax you need.