That is because the Selection.Numberformat = "@" clears the clipboard for a
copied range.

--
Regards,
Tom Ogilvy


"Roman" wrote in message
oups.com...
Thanks for any help on following:

What I'm trying to do is to paste something as a text to an area which
format is "@". As I don't know its size I paste it, then change the
format of selection (pasted area) to "@" and paste it again. This works
fine when data in clipboard is not from Excel, if it is this doesnt
work.

I noticed that cutcopymode is always 0 when the data in clipboard is
not from Excel. If it is the cutcopymode is 1 until there's this line
in the code:

selection.numberformat = "@"

after this cutcopymode is always changing to 0.

I don't have it.