Hi all,

I would like to copy the string variable 'Report' to clipboard, so I copied

...

' Copy results to clipboard

    Dim ccDO As New MSForms.DataObject

    ccDO.SetText Report, 1

    ccDO.PutInClipboard

    Set ccDO = Nothing

...

But I get the error

I've got another Macro, to copy BOM to clipboard, which uses the same statements and it works fine there.

Does anyone know the reason? Is there a way to solve the problem?

Thanks in advance for your help.