Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pastespecial
Hello,
I am pasting data to cells using Selection.PasteSpecial Using this I can only paste to another cell once. Using the clipboard viewer, I noticed that after the first paste the clipboard is cleared, preventing additional pastes. Any help will be appreciated. thanks bill q |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
pastespecial
and no I am not pasting into part of the copied range
"Tom Ogilvy" wrote in message ... Are you pasting into part of the copied range or otherwise altering it. This will clear the clipboard. If I don't alter the source range, I can paste special multiple times. Regards, Tom Ogilvy "billQ" wrote in message ... Hello, I am pasting data to cells using Selection.PasteSpecial Using this I can only paste to another cell once. Using the clipboard viewer, I noticed that after the first paste the clipboard is cleared, preventing additional pastes. Any help will be appreciated. thanks bill q |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
pastespecial
thank-you very much
"Tom Ogilvy" wrote in message ... The code that unprotects the sheet causes the clipboard to be cleared for me. It copied fine, but I couldn't paste even once (xl2000 - recognize you are using xl2002). If I commented out the protect/unprotect code, it worked repeatedly for me. If I ran it like this: Sub CopyHours() ActiveCell.Copy End Sub Sub PasteHours() Selection.PasteSpecial Paste:=xlPasteValues End Sub Sub setprotect() ActiveSheet.Protect UserInterfaceOnly:=True End Sub It worked fine. I protect the sheet with the UserInterfaceOnly:=true setting and I didn't need to unprotect in the Pastehours macro - so the clipboard didn't get cleared. You would need to set this each time the workbook is opened. Regards, Tom Ogilvy "billQ" wrote in message ... and no I am not pasting into part of the copied range "Tom Ogilvy" wrote in message ... Are you pasting into part of the copied range or otherwise altering it. This will clear the clipboard. If I don't alter the source range, I can paste special multiple times. Regards, Tom Ogilvy "billQ" wrote in message ... Hello, I am pasting data to cells using Selection.PasteSpecial Using this I can only paste to another cell once. Using the clipboard viewer, I noticed that after the first paste the clipboard is cleared, preventing additional pastes. Any help will be appreciated. thanks bill q |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
key shortcut for PasteSpecial-Values | Excel Discussion (Misc queries) | |||
PasteSpecial Error 1004? | Excel Discussion (Misc queries) | |||
PasteSpecial Method Error | Excel Discussion (Misc queries) | |||
Copy Chart and PasteSpecial | Charts and Charting in Excel | |||
Copy and pastespecial without formulas | Excel Programming |