View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mcmilja mcmilja is offline
external usenet poster
 
Posts: 35
Default Is there a shortcut to copy data from Formula Bar?

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