Copy content

Hi Guys,

Currently, i've got this macro:

Please Login or Register  to view this content.

This code copies a sheet from one file to another. But, i don't want to copy the sheet, but only the content and place this content in another (already existing) sheet.

I Tried this code

Please Login or Register  to view this content.

But it doesn't seem to work. What do i do wrong?

not completesly clear to me

however try this satement

Please Login or Register  to view this content.

I assume strnameworkheet is the object of the second sheet.

Well,
From file A, i want to fill a worksheet (allready existing) with a worksheet from file B. Thats the meaning.

This is currently my code.

Please Login or Register  to view this content.

Still, no values are being pasted. How can i check if the the copy-rule ( Sheets(2).Cells.Range("A1").Copy) works well? Or does any1 see what's wrong in my code?

Gr.

Any1 who can help me?

Not exactly clear what you want to do. Here's an example - copy SourceWorkbook.Sheets(2) values to the current_book.Sheets("CPF")

Please Login or Register  to view this content.