| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Works every second time
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  -- hih ------------------------------------------------------------------------ hih's Profile: http://www.excelforum.com/member.php...o&userid=30672 View this thread: http://www.excelforum.com/showthread...hreadid=503315 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Works every second time
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. "hih" wrote: 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 -- hih ------------------------------------------------------------------------ hih's Profile: http://www.excelforum.com/member.php...o&userid=30672 View this thread: http://www.excelforum.com/showthread...hreadid=503315 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Works every second time
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. hih wrote: 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 -- hih ------------------------------------------------------------------------ hih's Profile: http://www.excelforum.com/member.php...o&userid=30672 View this thread: http://www.excelforum.com/showthread...hreadid=503315 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro that works one time every day | Excel Discussion (Misc queries) | |||
| Time for M$ to fix incompatibility with Office & Works | Excel Discussion (Misc queries) | |||
| how do I create a hyperlink that works more than one time | Excel Discussion (Misc queries) | |||
| CopyPicture only works second time | Excel Programming | |||
| RPC ERROR - 1ST TIMES WORKS FINE - 2ND TIME ERRORS OUT | Excel Programming | |||
Hybrid Mode
