If you don't want to use a formula, then the macro would be:

Sub mailit_II()
Range("G3").Activate
Application.SendKeys "{F2}"
Application.SendKeys "{ENTER}"
End Sub
--
Gary's Student
gsnu200708


"Brettjg" wrote:

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.