Copy excel data to notepad.

What is the best way to copy data from excel, say 1 column, to notepad. Ideally it should be an automated process.

Please Login or Register  to view this content.

The above code works for a brand new workbook but not mine for some reason. I don't know what setting I would have changed that the code would skip over

Please Login or Register  to view this content.

though. Any suggestions?

Hi
Upload sample data that you are trying to copy into notepad.