Copy/Paste of separated columns
 

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

Could you paste column A and D into another spreadsheet (which will eliminate
the blank columns) and then copy and paste to your program from that? It
seems crude to have to take that extra step, but just a thought.

Brett

"mareku" wrote:

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

If I hid columns B:C, I could copy A thru D and paste into notepad and only
columns A and D showed up.

Maybe it'll work with your other program, too.

mareku wrote:

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

--

Dave Peterson