Vba copy to clip board

[eddbod]

i have a dimmed string - ans
and want to copy the string to the clipboard so that it can be pasted into word etc
can someone help me with some coding

[royUK]

Here's an example that you can adapt

[jonnyaykroyd]

Try this:

Please Login or Register  to view this content.

Hope this is what you need.