Works every second time

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hih - 20 Jan 2006 13:47 GMT

Hello!
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False

In one of my Sub's this Paste-function only work every second time.
Can you help me to make it work -every- time?

hih:confused:

Signature

hih

Reply to this Message

DaveO - 20 Jan 2006 13:59 GMT

Without seeing the rest of the code, I'm going to guess that the 'Selection.'
part is the bit thats causing you your issue here.

If you post the rest of at least post how the selction is derived it may help.

HTH.

> Hello!
> Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, _
[quoted text clipped - 4 lines]
>
> hih:confused:

Reply to this Message

Dave Peterson - 20 Jan 2006 18:06 GMT

My guess is that you do something that clears the clipboard.

You could add this to check:

msgbox application.cutcopymode
if it's false, your pastespecial will fail.

Either rearrange the pasting lines in a nice fashion or just copy the original
range before you try pasting again.

> Hello!
> Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, _
[quoted text clipped - 10 lines]
> hih's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30672
> View this thread: http://www.excelforum.com/showthread.php?threadid=503315

Signature

Dave Peterson

Reply to this Message