Copying Worksheets from one book to another
 

hello everyone, I think I found my solution:

This copies from the source sheet, all the cells and pastes it in
the destination sheet.

code:

SrcSheet.Range("A1:J700").Copy()
DstSheet.Range("A1").PasteSpecial(Excel.XlPasteTyp e.xlPasteAll)


The problem I am having though is that it doesn't paste the cells
instead it pastes some image of the cells, so i can't manipulate the
for some reason. Isn't that wierd? Instead of copying each individua
cell and pasting it over, instead it copies all the cells in a gian
block as a bit map and copies it over so i can't do anything with th
data in the destination worksheet.

help

--
Message posted from http://www.ExcelForum.com

Copying Worksheets from one book to another
 

SrcSheet.Range("A1:J700").Copy Destination:=DstSheet.Range("A1")

Would be the way to do it in a single instance of Excel. If you have
multiple instances of Excel open, then I would be hard to imagine why you
would need to do that.

--
Regards,
Tom Ogilvy

"Jonx " wrote in message
...
hello everyone, I think I found my solution:

This copies from the source sheet, all the cells and pastes it in
the destination sheet.

code:

SrcSheet.Range("A1:J700").Copy()
DstSheet.Range("A1").PasteSpecial(Excel.XlPasteTyp e.xlPasteAll)


The problem I am having though is that it doesn't paste the cells,
instead it pastes some image of the cells, so i can't manipulate them
for some reason. Isn't that wierd? Instead of copying each individual
cell and pasting it over, instead it copies all the cells in a giant
block as a bit map and copies it over so i can't do anything with the
data in the destination worksheet.

help?


---
Message posted from http://www.ExcelForum.com/

Copying Worksheets from one book to another
 

Hi,
I copied your code and tried it on one of my files. I got
a complier error on the first line. I had to remove the
brackets after copy. after that it worked fine. copied
cell for cell.
-----Original Message-----
hello everyone, I think I found my solution:

This copies from the source sheet, all the cells and
pastes it in
the destination sheet.

code:

SrcSheet.Range("A1:J700").Copy()
DstSheet.Range("A1").PasteSpecial
(Excel.XlPasteType.xlPasteAll)


The problem I am having though is that it doesn't paste
the cells,
instead it pastes some image of the cells, so i can't
manipulate them
for some reason. Isn't that wierd? Instead of copying
each individual
cell and pasting it over, instead it copies all the cells
in a giant
block as a bit map and copies it over so i can't do
anything with the
data in the destination worksheet.

help?


---
Message posted from http://www.ExcelForum.com/

.