View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bsharp bsharp is offline
external usenet poster
 
Posts: 13
Default Can't get email addresses to be "hot" when using lookup

Jacob -

Thanks, that worked.

At first I thought it wasn't working, until I tried having the other
workbook open that I'm pulling the email from, and then it worked.

It's funny because it will pull the email address into the cell and display
it even when the other workbook is closed, but the hot link won't generate an
email message unless the other workbok is open. If you have a solution for
that, I'd love to know.