Shortcut for Paste Special Values

T

tod

I have a wild haired idea. (Wild haired? Hair Brained? Wild Eyed?)
ANYWAY, is there a way in VBA I can test what kind of contents are in
the clipboard? I was thinking if I copied something like formulas or
Access data or some other where I want the results pasted as CSV, I
could use just the standard paste command and then have the code test
what I'm pasting and automatically paste it as CSV if it meets the
criterion. Should I just be quiet and go back to playing with my
little numbers, or could something like that work? Or does it already
exist and I just don't know it?

tod
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top