I am trying to extract the hyperlink address of cell I2 in Excel using VBScript of PAD (please see the attached picture). This is the VBA code.
Function GetLinkAddress() As String GetLinkAddress = ActiveSheet.Range("I2").Hyperlinks(1).Address
End Function
And the result is '1' as shown in the attached picture. If any expert can tell me why hyperlink extraction fails and how to extract it, I would appreciate it.
Your script code is not allowed I guess, one thing please clarify that when you say VBScript <> VBA.
Please describe how do you want to manipulate the hyperlink address.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
2
Share
Report
All responses (
Answers (
