It is hard to understand exactly how you have designed the Macro. It would be best to upload your macro .
Also, unless you need to store images, rich text, or other complex objects, there is little need for Named Clipboards. It is usually better to store plain text as a Global Variable.
Please read:
Tip: How Do I Get The Best Answer in the Shortest Time?