Hyperlink function presents variable results does not work in macro
 

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

--
Message posted via http://www.officekb.com

Hyperlink function presents variable results does not work in macro
 

As ALWAYS, post your coding efforts for comments.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"enahs_naneek via OfficeKB.com" <u58016@uwe wrote in message
news:a34c4b034a8c9@uwe...
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

--
Message posted via http://www.officekb.com