copying AS IS

C

chipsy

Joined
Feb 20, 2007
Messages
5
Reaction score
0
hi
how do i copy a range of a sheet to the same range of another sheet AS IS (with formatting and row/column dimensions) using vba?

thanks
 
i've resolved it by:
Code: 
Worksheets("SheetX").Cells.Copy
 With Worksheets("SheetY")
 .Cells.PasteSpecial xlValues
 .Cells.PasteSpecial xlFormats
 End With
 
You must log in or register to reply here.

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

Eliminate blanks while copy row and transpose 11
Copy columns and paste with blank column between 5
Paste in column B using Last row of either column B, C or D. 10
Code copies twice...? 13
Want code to copy to ABOVE row 22 column A on sheet 1 10
Formatting and copy or copy and formatting ?? 2
Copy .Areas.Item(1,2,3,4,5, etc.) to a column or a row 5
My Never ending ARRAY code problems 18

Back
Top