How can I copy data from Excel into notepad?

Hi I am wanting to copy some excel data into NOTEPAD using VBA. I have got the stuff I want to copy in the clipboard via Columns("A:A").Select Selection.Copy I have written the VBA to open notepad, but how do I copy the clipboard ??? as I get " Runtime error 424... show more Hi
I am wanting to copy some excel data into NOTEPAD using VBA.
I have got the stuff I want to copy in the clipboard via
Columns("A:A").Select
Selection.Copy
I have written the VBA to open notepad, but how do I copy the clipboard ???
as I get " Runtime error 424 " object required

Rgds
Stefan
2 answers 2