Hyperlink works but text displayed says 0

[Peter Thompson]

All,

I am having an issue with Hyperlinks. Both the address and the text to display use the same string variable, however, while the hyperlink will open up the file the text being diplayed in the cell just says 0.

I have bolded th ehyperlink lines for quick reference.

Has anyone come accross this before?

strextensionoutputrefs3 = Mid(strOutputRefs, Len(strOutputRefs) - 3, 1)
StrextensionOutputRefs4 = Mid(strOutputRefs, Len(strOutputRefs) - 4, 1)

If strextensionoutputrefs3 = "." Or strextensionoutpurefs4 = "." Then

wksData.Hyperlinks.Add anchor:=Cells(i, 19), Address:= _
strOutputRefs _
, TextToDisplay:= _
strOutputRefs

Else


End If

 

[Jerry Sullivan]

Peter, That's really strange.
Is there anything special going on in your worksheet that could affect those cells, such as Event code or Data Validation?

There appears to be a typo in one variable name:
If strextensionoutputrefs3 = "." Or strextensionoutpurefs4 = "." Then

...but that shouldn't cause the problem you describe.