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