VBA for filling a clipboard giving question marks in boxes issue

[scottiex]

I have been using this code in a file I am distributing

Please Login or Register  to view this content.

It puts data in a clipboard. however for one user it failed and I get just two question marks in boxes. This is a known issue apparently on Microsoft's side.

So there is the alternative (a version of what they suggested but updated as per a stack overflow post.

Please Login or Register  to view this content.

However having run that code (playing around and stepping through it) it has now broken my system so that it can't run the first code.
No problem since it seems o have reset from just leaving all the excel and restarting it - However this has me thinking, there might be a way to reverse it and run the first code on their computer?

Does anyone have any ideas what changed on my computer and if there is a way in the code to get it back to so that it can run the first code on this outher users computer and we can have a more direct work around for the microsoft issue?

[scottiex]

Currently I am pushing out the rather lame solution of just pasting the data to the sheet and copying it again.
Would be nice (and i think helpful to a lot of other people) to better understand the problem though.