well...

Clpbrd.exe will tell you what's on the clipboard.
copy a cell and check it out.

Be sure to use the View dropdown to see all the datatypes
such a 'basic copy' puts in the clipboard.

Freely filling the clipboard cannot be easily done VBA,
you'll need to use API's for that and it will be very complex
if you go beyond the very basic (documented) datatypes


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


gabor salai wrote :

with "copy/paste" [say some range], does excel use clipboard, or some
internal structure?
after "copy", is it possible to somehow access that buffer [before
"paste"], and to examine it, or even programaticaly select [or apply]
just a part of buffer.
it is something like "paste special" does, but i would like to have
full [free] user intervention.
it would be also intersting to programaticaly [freely] fill that
"copy/paste" buffer.