Hi Terry,
While CopyPaste to avoid the hidden rows/cols, just the CopyTextToBuffer method can be implemented and called in the ClipboardCopy event handler. Attached is a sample that demonstrates this. Let us know if this serves your need.
Regards,
Calvin.
CopyTextToBuffer.zip