Copy to clipboard all cell content?

Hello,

How to copy cell value to clipboard?

Please Login or Register  to view this content.

On sheet One in L14 is formula. I then copy that cell to sheet TWO in L12 as value.
Now, problem is, I need to manually select cell L12 and go to formula bar to select all cell content and then keyboard CTRL+C to copy to clipboard and then go to remote desktop connection to paste that clipboard value. It's not pasting when I0m using "standard" VBA code for copying.

ActiveCell.FormulaR1C1=" how to select all content? That is the questiion."

Thanks in advance!

Originally Posted by rorya

No. If you want L12, then you need to use:

Please Login or Register  to view this content.

instead of:

Please Login or Register  to view this content.

YES YES YES, thank you Rory, God Bless You!! thanks excelforum, since 2014 helped me a ton!