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
.