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.
|