Copy and paste

B

Ben

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
 
J

Jim Rech

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

[email protected]...
| 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy/Paste and remove blanks VBA 0
How to use OFFSET in VBA 1
vba powerpoint pasting named shape in selected named slides 0
Copy cell value from one worksheet to matching worksheet in another workbook 4
Find matches in different spreasheets then copy and paste to new s 15
Macro to copy value in field and insert it into filter 2
Create if partial match then copy and paste data from one cell to another 1
VBA code for pasting links -- modifying RDB code for summary workbook 10

Top