hi,

i'm trying to cut and paste from 1 excel worksheet to anotherworksheet. can
this be done?

Have you tried it? What happened?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"cj" <(E-Mail Removed)> wrote in message
news:E6C77EE7-96C8-478F-9D74-(E-Mail Removed)...
> hi,
>
> i'm trying to cut and paste from 1 excel worksheet to anotherworksheet.
> can
> this be done?

Nothing happens, when i go to the new worksheet it won't let me paste

"Don Guillett" wrote:

> Have you tried it? What happened?
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> (E-Mail Removed)
> "cj" <(E-Mail Removed)> wrote in message
> news:E6C77EE7-96C8-478F-9D74-(E-Mail Removed)...
> > hi,
> >
> > i'm trying to cut and paste from 1 excel worksheet to anotherworksheet.
> > can
> > this be done?
>
>

The key word here is NEW. Make the new ws before you cut/paste from the old
one.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"cj" <(E-Mail Removed)> wrote in message
news:2AC4CE94-C4B0-4E4C-A11C-(E-Mail Removed)...
> Nothing happens, when i go to the new worksheet it won't let me paste
>
> "Don Guillett" wrote:
>
>> Have you tried it? What happened?
>>
>> --
>> Don Guillett
>> Microsoft MVP Excel
>> SalesAid Software
>> (E-Mail Removed)
>> "cj" <(E-Mail Removed)> wrote in message
>> news:E6C77EE7-96C8-478F-9D74-(E-Mail Removed)...
>> > hi,
>> >
>> > i'm trying to cut and paste from 1 excel worksheet to anotherworksheet.
>> > can
>> > this be done?
>>
>>

return with error: can't paste: data on the clipboard is not the same size
and shape as the selected area. i'm trying to cut and paste between 2
different excel worksheets. i have 2 different worksheets open, i'm not
cutting and pasting between 2 different worksheets within the same excel, but
2 different excel programs.

"Don Guillett" wrote:

> The key word here is NEW. Make the new ws before you cut/paste from the old
> one.
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> (E-Mail Removed)
> "cj" <(E-Mail Removed)> wrote in message
> news:2AC4CE94-C4B0-4E4C-A11C-(E-Mail Removed)...
> > Nothing happens, when i go to the new worksheet it won't let me paste
> >
> > "Don Guillett" wrote:
> >
> >> Have you tried it? What happened?
> >>
> >> --
> >> Don Guillett
> >> Microsoft MVP Excel
> >> SalesAid Software
> >> (E-Mail Removed)
> >> "cj" <(E-Mail Removed)> wrote in message
> >> news:E6C77EE7-96C8-478F-9D74-(E-Mail Removed)...
> >> > hi,
> >> >
> >> > i'm trying to cut and paste from 1 excel worksheet to anotherworksheet.
> >> > can
> >> > this be done?
> >>
> >>
>
>

If you have different instances of XL, you can't copy between them.
I believe that each instance of XL has it's *own* clipboard.

Also, that error message comes up when you are trying to copy and paste
*merged* cells.
If that be the case, UNMERGE them!
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"cj" <(E-Mail Removed)> wrote in message
news:5CFC822B-E7FF-4E51-A6E9-(E-Mail Removed)...
> return with error: can't paste: data on the clipboard is not the same size
> and shape as the selected area. i'm trying to cut and paste between 2
> different excel worksheets. i have 2 different worksheets open, i'm not
> cutting and pasting between 2 different worksheets within the same excel,
> but
> 2 different excel programs.
>
> "Don Guillett" wrote:
>
>> The key word here is NEW. Make the new ws before you cut/paste from the
>> old
>> one.
>>
>> --
>> Don Guillett
>> Microsoft MVP Excel
>> SalesAid Software
>> (E-Mail Removed)
>> "cj" <(E-Mail Removed)> wrote in message
>> news:2AC4CE94-C4B0-4E4C-A11C-(E-Mail Removed)...
>> > Nothing happens, when i go to the new worksheet it won't let me paste
>> >
>> > "Don Guillett" wrote:
>> >
>> >> Have you tried it? What happened?
>> >>
>> >> --
>> >> Don Guillett
>> >> Microsoft MVP Excel
>> >> SalesAid Software
>> >> (E-Mail Removed)
>> >> "cj" <(E-Mail Removed)> wrote in message
>> >> news:E6C77EE7-96C8-478F-9D74-(E-Mail Removed)...
>> >> > hi,
>> >> >
>> >> > i'm trying to cut and paste from 1 excel worksheet to
>> >> > anotherworksheet.
>> >> > can
>> >> > this be done?
>> >>
>> >>
>>
>>

I have never had a problem copying and pasting between different instances
of XL!

Are you selecting more than one cell when you're pasting?
I agree with RagDyer that unmerging may need to occur.

Rob

"RagDyer" <(E-Mail Removed)> wrote in message
news:Op%(E-Mail Removed)...
> If you have different instances of XL, you can't copy between them.
> I believe that each instance of XL has it's *own* clipboard.
>
> Also, that error message comes up when you are trying to copy and paste
> *merged* cells.
> If that be the case, UNMERGE them!
> --
> HTH,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "cj" <(E-Mail Removed)> wrote in message
> news:5CFC822B-E7FF-4E51-A6E9-(E-Mail Removed)...
>> return with error: can't paste: data on the clipboard is not the same
>> size
>> and shape as the selected area. i'm trying to cut and paste between 2
>> different excel worksheets. i have 2 different worksheets open, i'm not
>> cutting and pasting between 2 different worksheets within the same excel,
>> but
>> 2 different excel programs.
>>
>> "Don Guillett" wrote:
>>
>>> The key word here is NEW. Make the new ws before you cut/paste from the
>>> old
>>> one.
>>>
>>> --
>>> Don Guillett
>>> Microsoft MVP Excel
>>> SalesAid Software
>>> (E-Mail Removed)
>>> "cj" <(E-Mail Removed)> wrote in message
>>> news:2AC4CE94-C4B0-4E4C-A11C-(E-Mail Removed)...
>>> > Nothing happens, when i go to the new worksheet it won't let me paste
>>> >
>>> > "Don Guillett" wrote:
>>> >
>>> >> Have you tried it? What happened?
>>> >>
>>> >> --
>>> >> Don Guillett
>>> >> Microsoft MVP Excel
>>> >> SalesAid Software
>>> >> (E-Mail Removed)
>>> >> "cj" <(E-Mail Removed)> wrote in message
>>> >> news:E6C77EE7-96C8-478F-9D74-(E-Mail Removed)...
>>> >> > hi,
>>> >> >
>>> >> > i'm trying to cut and paste from 1 excel worksheet to
>>> >> > anotherworksheet.
>>> >> > can
>>> >> > this be done?
>>> >>
>>> >>
>>>
>>>
>
>

RD

You can copy between instances but only as values and the Paste Special dialog
is much different and only allows pasting as Object and other formats.

I do agree with the "merged cells" hypothesis.


Gord


On Fri, 7 Dec 2007 16:29:23 -0800, "RagDyer" <(E-Mail Removed)> wrote:

>If you have different instances of XL, you can't copy between them.
>I believe that each instance of XL has it's *own* clipboard.
>
>Also, that error message comes up when you are trying to copy and paste
>*merged* cells.
>If that be the case, UNMERGE them!

It is always thoughtful to tell us the WHOLE story in the
beginning.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"cj" <(E-Mail Removed)> wrote in message
news:5CFC822B-E7FF-4E51-A6E9-(E-Mail Removed)...
> return with error: can't paste: data on the clipboard is not the same size
> and shape as the selected area. i'm trying to cut and paste between 2
> different excel worksheets. i have 2 different worksheets open, i'm not
> cutting and pasting between 2 different worksheets within the same excel,
> but
> 2 different excel programs.
>
> "Don Guillett" wrote:
>
>> The key word here is NEW. Make the new ws before you cut/paste from the
>> old
>> one.
>>
>> --
>> Don Guillett
>> Microsoft MVP Excel
>> SalesAid Software
>> (E-Mail Removed)
>> "cj" <(E-Mail Removed)> wrote in message
>> news:2AC4CE94-C4B0-4E4C-A11C-(E-Mail Removed)...
>> > Nothing happens, when i go to the new worksheet it won't let me paste
>> >
>> > "Don Guillett" wrote:
>> >
>> >> Have you tried it? What happened?
>> >>
>> >> --
>> >> Don Guillett
>> >> Microsoft MVP Excel
>> >> SalesAid Software
>> >> (E-Mail Removed)
>> >> "cj" <(E-Mail Removed)> wrote in message
>> >> news:E6C77EE7-96C8-478F-9D74-(E-Mail Removed)...
>> >> > hi,
>> >> >
>> >> > i'm trying to cut and paste from 1 excel worksheet to
>> >> > anotherworksheet.
>> >> > can
>> >> > this be done?
>> >>
>> >>
>>
>>

I seldom if ever use different instances but could swear that I found
pasting between instances impossible.
However, you guys are right and I'm wrong.
It works on every version I've got, so I guess I use my old, standby excuse
.... I'm old and my memory is failing.

I guess that's one of the perks of old age.
Blame it on the years and not on your stupidity!<bg>

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:(E-Mail Removed)...
> RD
>
> You can copy between instances but only as values and the Paste Special
dialog
> is much different and only allows pasting as Object and other formats.
>
> I do agree with the "merged cells" hypothesis.
>
>
> Gord
>
>
> On Fri, 7 Dec 2007 16:29:23 -0800, "RagDyer" <(E-Mail Removed)>
wrote:
>
> >If you have different instances of XL, you can't copy between them.
> >I believe that each instance of XL has it's *own* clipboard.
> >
> >Also, that error message comes up when you are trying to copy and paste
> >*merged* cells.
> >If that be the case, UNMERGE them!
>