Hi,
Could you please guide me how to add hyperlink in excel using Invoke Code method. Please find the code given below, the one I tried.
Vb.Net Code:
With shXL(1)
.Hyperlinks.Add Anchor:=.raXL(“a5”), _
Address:=“http://example.microsoft.com”, _
ScreenTip:=“Microsoft Web Site”, _
TextToDisplay:=“Microsoft”
End with
Kindly let me know if i have to change anything in the code and also teach how to do it using Invoke code method.