VBA command for copying active cell content only

[bhupender]

Hello folks,
I tried the whole internet but couldnt find vba code for.
selecting active cell , then
f2 command, then
selecting all the content of the cell, then
copy all the content.

I have to enter a lot of data from excel to external application which support only values and not normal data copied from excel.

Please help, it looks easy, but doesnt have much knowledge of vba.

thanks

 

[bhupender]

Yes, indeed I thought at first this is simple and a macro recorder will do the trick but as soon as I press F2 the recorder stop recording.

I thought sendkey command will do but I am not an expert on this subject.

 

[My Aswer Is This]

And your still saying if you run the script I gave you.

And then switch over to a application like Note Pad and then press "Ctrl+ V" which is the command for "Paste" you say nothing is pasted.
And you realize you said copy "Active cell" Not "Selection"

In your original post you said copy Active cell. That is only the contents of the active cell not the contents of a Range of cells.

 

[bhupender]

Exactly, nothing gets pasted in the application. by the way the application is MYOB which is an accounting application. I need to copy a cell where an invoice number is written. but if i simply copy (or even after using codes), it does copy the content but doesnt past it. on the other hand if I do F2+ select all+ copy then its got pasted.

So I was just looking for a code which can replicate these three keys which I am pressing to get the data copied from the active cell.

i hope I am clear in expressing what I want.

thanks