Copy and paste
 

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

Copy and paste
 

the cell shrink?

I'm not sure what that means. but if it's a result of formatting being
copied try copying just values:

ActiveCell.Copy
Workbooks.Add
ActiveCell.PasteSpecial xlPasteValues
Application.CutCopyMode = False

--
Jim Rech
Excel MVP

"Ben" wrote in message
news:4b5f01c473ae$f4e0bf50
...
| 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