Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping Workbook Name Out of Sheet When Copying to Different Book | Excel Discussion (Misc queries) | |||
Moving worksheets to another book - 2nd book will not appear | Excel Discussion (Misc queries) | |||
copy worksheets to new book without linking to original book | Excel Discussion (Misc queries) | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
Copying multiple sheets to a new book and undertake specialised ed | Excel Discussion (Misc queries) |