超鏈接查看太麻煩,Excel怎么快速提取單元格內(nèi)的超鏈接地址?
https://baijiahao.baidu.com/s?id=1640649015306258072&wfr=spider&for=pc
新建宏:
Function GetAdrs(Rng)
Application.Volatile True
With Rng.Hyperlinks(1)
GetAdrs = IIf(.Address = "", .SubAddress, .Address)
End With
End Function