F2, then shift + home, ctrl + c then esc


--


Regards,


Peo Sjoblom


"mcmilja" wrote in message
...
Hello,

I have created a database update macro using macroexpress which copies
data
from excel and pastes it into a database. I have the macro set up to
click
on a specific cell in the worksheet and it types ctrl+c to copy the data.
The problem is that 50% of the time when I copy from the cell, whether I'm
using my macro or copying manually, it does not paste into the field in
the
database. I have found that if I click on the cell and then copy the data
from the Formula Bar that it will paste into the database field 99% of the
time. So my question is, is there a shortcut to copy data from the
Formula
Bar that I can use in my macro?

Thanks,
Jaret