Hyperlink function presents variable results does not work in macro

[enahs_naneek via OfficeKB.com]

I need some assistance if possible using a hyperlink function within a macro
The hyperlink function is presenting the current address in excel (address
varies) but there is no change within the macro code
It appears that the macro once recorded cannot be "updated" to the address
that is current.
Is there a way around, through or over this.

I am using the hyperlink to select a range which can then be "updated" as
part of the macro

Thanks for any assistance

 

[Don Guillett]

As ALWAYS, post your coding efforts for comments.