I guess I'm going to address the seemingly obvious elephant in the room, I've been wrong many times before but I don't think that it's possible to paste an XL table to a text box and if even if U could, why would U? I don't see any reference to listobjects (XL tables) in the code above and both subs above appear identical? What do U really want to do... just display an XL tables on a word userform? Why not just generate a picture of the table and paste it in an image control or frame? Maybe there's an easier method to achieve you're desired outcome rather than the one you're requesting. HTH. Dave