I am trying to follow this hyperlink using vba...
=IF(A21="","",HYPERLINK("http://www.imdb.com/find?q="&SUBSTITUTE(A21,"
","%20"),"About "& "'" & A21 & "'")).

I've tried using '.Hyperlinks(1).Follow NewWindow:=True' but it's a formula
so I think thats whats giving me the trouble.

Thanks in Advance