My hyperlink works when I click the cell but it does not work with the macro

[emilt_milut]

Range("M6").Select<o></o>
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True<o></o>
Run time error 9: subscript out of range<o></o>
In other similar macros, the codeworks perfectly<o></o>
<o></o>
Thanks much for any suggestion<o></o>
Leon Traubkatz<o></o>

 

[Vbagreenhorn1]

try this:

ActiveWorkbook.FollowHyperlink Address:=Range("M6").Value, NewWindow:=False, AddHistory:=True

 

[Yongle]

I cannot recreate your problem if link is embedded in the cell
I can recreate your problem if the cell contains =HYPERLINK(...) function

Try to embedding the link in the cell
-Right-Click on cell \ Insert Hyperlink etc