Hi Jannie
I have this awful feeling that you are retyping what i give you... lol save urself the trouble and just Copy and Paste the code from here to VB. It works just fine. So, ur prob is just another typing error in that line.
Regards
Stuart

VB Code:
  1. 'You typed

  2. lstrClipCopy = lstrClipCopy & Trim$(llngRows, llngCols)

  3.  
  4. 'Should have been, as per original post

  5. lstrClipCopy = lstrClipCopy & Trim$(.TextMatrix(llngRows, llngCols))