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
Have you tried pasting your selection? Your clipboard may show columns A-D, but when you paste, only the selected data will be pasted. Note that this data will be pasted in concurrent columns, not separated as when you copied them. (e.g. A1, C1 will be pasted into D1,E1 not D1, F1)
HTH
Bruce
The older I get, the better I used to be.
USA
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
>
I am assuming from this post that you want to paste these columns into Word? If that is the case, yes, you could first paste into a blank area in Excel then copy/paste to Word.
You could also paste directly into Word, then highlight the 'blank' column(s) and delete them (hold the cursor over the top edge of the blank column until it turns into a black down arrow, click to select that column, then Right click and select "Delete Column").
Not pretty, but it works!
HTH
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks