Follow Concatenated Hyperlink

[dman78]

I have a concatenated hyperlink that is a folder on the drive in A1:

[CODE=vba]A1=CONCATENATE(A2,A3)

This is the code that does not work. It does not return the hyperlink because I am assuming it's concatenated. Is there a way to resolve this?

Sub Go_To_Folder()
Range("A1").Select
Selection.Hyperlinks(1).Follow
End Sub

Nothing happens when I run this code.... any ideas how to go to the folder on the drive?

Many thanks!

 

[Tetra201]

Try

Sub Go_To_Folder()
    ActiveWorkbook.FollowHyperlink Range("A1")
End Sub