ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Copy/Paste of separated columns from Excel to a thirdparty application (https://www.excelbanter.com/excel-programming/320112-copy-paste-separated-columns-excel-thirdparty-application.html)

mareku

Copy/Paste of separated columns from Excel to a thirdparty application
 
If you select column A and D in Excel and copy them into the Clipboard
you will see that there are actualy four columns A, B, C, D in the
Clipboard. (I use Clipbrd.exe to view the clipboard).

Does anyone knows workarround for it? I want to paste the columns into
my own program, but not all of them, just the selected. I have noticed
that even Word Paste command works this way. Yet maybe someone has
already solved this problem.

Thanks
Marek

Tom Ogilvy

Copy/Paste of separated columns from Excel to a thirdparty application
 
Why not paste them in two adjacent columns, then copy them from there.
Later you can clear the temporary copy.

--
Regards,
Tom Ogilvy

"mareku" wrote in message
om...
If you select column A and D in Excel and copy them into the Clipboard
you will see that there are actualy four columns A, B, C, D in the
Clipboard. (I use Clipbrd.exe to view the clipboard).

Does anyone knows workarround for it? I want to paste the columns into
my own program, but not all of them, just the selected. I have noticed
that even Word Paste command works this way. Yet maybe someone has
already solved this problem.

Thanks
Marek





All times are GMT +1. The time now is 05:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com