View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
JP[_4_] JP[_4_] is offline
external usenet poster
 
Posts: 897
Default How to extract "destination address" from Hyperlink - VBA

What I meant was "a check of the "komorka" variable shows that it is
equal to the value in cell A1, not a range reference to A1"

--JP


On Oct 23, 12:53*pm, JP wrote:
I duplicated your example, but was not able to duplicate the error.
The function exited immediately after hitting "If
komorka.Hyperlinks.Count = 0 Then " and a check of the 'komorka' shows
that it is equal to 100, not a range reference to A1.

--JP

On Oct 23, 12:13*pm, spwmarluk wrote: