Appending text to clipboard using Excel VBA

Hi all,

I am searching the solution for my following problem.

I am copying any random range from a worksheet. I'm copying it as image in clipboard.
Now, I want to add text to bottom of clipboard image sothat I can get whenever the contents of clipboard(i.e. the copied range) are pasted.
I need to do this while copying, not while pasting it.

Can anybody suggest solution?

regards,
kapil

Add temporary row to the bottom of the range. Put your text in the temporary row.
Copy the range including the temporary rows.
Delete the temporary row.