View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
MIKESX MIKESX is offline
external usenet poster
 
Posts: 3
Default Activate web link via image object

Hi Nick:

All one line, same error. Still wants an equal sign where the
amperzand is.

Michael


Seems the code became unfortunately split. This is all a single line however
it look in your reader:
ThisWorkbook.FollowHyperlink
Application.Worksheetfunction.Lookup(.Range("H20") ,SourceWS.Range("FM3:
FM27"),SourceWS.Range("FN3:FN27"))&.Range("E16")