When I copy a cell that has an email address created by a formula, it doesn't
work as a hyperlink. I copy & pastevalues but still doesn't work. However, I
notice that I only have to doubleclick on the pasted cell and then just press
enter and it works properly.

Sooooo, how do I force VB to perform an automatic doubleclick in cell G3,nd
then press enter? It will be the same cell every time, not variable. That is
to say that I don't want to manually doubleclick or press enter at all. Or is
there a better way to paste info into the cell that makes it work as a
hyperlink? Styling the cell doesn't work.