Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
popup warning
From time to time, excel prompts Windows clipboard does not contain data in
a supported format. Does this related to my macro which has lots of copy/cut and paste and I placed Application.CutCopyMode = False after each action of paste action. How do I avoid the popup again please? Rgds |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
popup warning
There are some things that cause the clipboard to get cleared. If you've copied
something, then the macro stopped and you wanted another macro to paste, then this may not work--most macros clear that clipboard. But if it's in the same workbook, I try to keep my copy/cut's right near the associated pastes. Dim RngToCopy as range dim DestCell as range with worksheets("Somesheet") set rngtocopy = .... end with with worksheets("someothersheet") set destcell = .... end with 'lots and lots of code here. rngtocopy.copy _ destination:=destcell Seeker wrote: From time to time, excel prompts Windows clipboard does not contain data in a supported format. Does this related to my macro which has lots of copy/cut and paste and I placed Application.CutCopyMode = False after each action of paste action. How do I avoid the popup again please? Rgds -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
popup warning
Hi John and Peter,
As I am a tyro in the VBA, my project was done by the excel recorder and kind donation of codes from experts in this forum. I understand set/dim, as/=, variant/string etc should be used in programming to make it reliable and efficiency, but I have no knowledge of these setting thats why I use copy/paste instead. Any wed page that you would suggest that I can learn these setting please? Rgds "Dave Peterson" wrote: There are some things that cause the clipboard to get cleared. If you've copied something, then the macro stopped and you wanted another macro to paste, then this may not work--most macros clear that clipboard. But if it's in the same workbook, I try to keep my copy/cut's right near the associated pastes. Dim RngToCopy as range dim DestCell as range with worksheets("Somesheet") set rngtocopy = .... end with with worksheets("someothersheet") set destcell = .... end with 'lots and lots of code here. rngtocopy.copy _ destination:=destcell Seeker wrote: From time to time, excel prompts âœWindows clipboard does not contain data in a supported formatâ. Does this related to my macro which has lots of copy/cut and paste and I placed âœApplication.CutCopyMode = Falseâ after each action of paste action. How do I avoid the popup again please? Rgds -- Dave Peterson . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
UNDO DELEING ROW AND POPUP WARNING MESSAGE | Excel Programming | |||
How to turn off the popup warning when clicking on a hyperlink | Excel Worksheet Functions | |||
How to stop the popup warning window when clicking on a hyperlink | Excel Programming | |||
Add a warning popup to a Macro Button | Excel Worksheet Functions | |||
Protection and warning popup | Excel Discussion (Misc queries) |