View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default Re : Excel Control-"C" to Copy an ActiveCell

It does work but it is dependant on exactly what you are doing. For example
if you create a forms button on a worksheet and then attach the following
code to the button then when you click the button, it will copy A1.

Sub test()
Range("A1").Select
Application.SendKeys ("^c")
End Sub

However, if you are in the VBA editor and highlight (select) the line
Range("A1").Select
and then run the code from the VBA editor and then move the cursor to a
blank area of the editor and paste you will see that it has copied the
selected text in the VBA editor.

Out of curiousity why would you want to use Senkeys to copy?

--
Regards,

OssieMac


" wrote:

It appears that the following VBA statement,

Application.SendKeys ("^C")

does not copy the ActiveCell (as per intention), but why ?

Please share your experience. Regards.