parscon
10-29-2013, 02:14 PM
I am trying to retrieve the address (file path) from a Hyperlink in a cell using VBA and i have this VBA code bit it is work just for A1 that mean first record.
I need to check all row of column A .
Please help me .
Thank you
Sub GetCellAddress()
cellAddress = Replace(Range("A1:A200").Hyperlinks(1).Address, "Hyperlink", "")
MsgBox cellAddress
Cells(1, 2) = cellAddress
End Sub
I need to check all row of column A .
Please help me .
Thank you
Sub GetCellAddress()
cellAddress = Replace(Range("A1:A200").Hyperlinks(1).Address, "Hyperlink", "")
MsgBox cellAddress
Cells(1, 2) = cellAddress
End Sub