View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
 
Posts: 1,522
Default 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