merging two sheet by VBA: missing rows

[vermaccio]

i tried to merge 2 sheets by VBA but i have some problems in result.
see attached sheet.

there are 5 sheets:
sheets "area100 datas" and "area200 datas" are raw datas.
sheets "area100" and "area200" extract raw datas, filter and reorder them.
so ignore those 4 sheets, are the starting sheets.

then there is a VBA in the sheet "area100+200" (see the button) that should merge "area100" and "area200" sheets.
(note: the copy/paste looks for the real number of rows to be copied because row number can change).

here is the problem:
some row of sheet "area200" is not copied (in the attached file are missing 2 rows).

any idea?

[vermaccio]

i see that ion the area100+200 sheet there are formulas (???) while the copy/paste should copy values. is this the problem? how to solve it?

[JEC.]

If it's only about 2 sheets, then this is the fasted way (using arrays to write directly to sheet 1, instead of copy/paste)

Please Login or Register  to view this content.

[vermaccio]

solved. was missing the "Paste:=xlPasteValues" at the end of paste code.

tomorrow i will try your solution it's shorter

[JEC.]

Note that every select/activate in VBA is unnecessary. They make your code very slow.

[vermaccio]

Ok. How can I change my code without select/activate? How canvba know the sheet is working on?

[JEC.]

For example, this is how you paste a1 from sheet 1 to sheet 2. Look at how I refer to specific sheets:

Sheets(1).[A1].copy sheets(2).[A1]

[vermaccio]

thank you. problem solved.