Hi,

I am using the VB to copy and paste the text to a new
sheet in a new workbook but after pasting, the cell
shrink? how to prevent it uding VBA?

Regards,
Ben