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