Macro to merge 2 sheets to one and keep header row

Originally Posted by Capcel

Jindon, that works.

Good.

Originally Posted by Capcel

cheeze83 I get an error with that line
activesheet.pastespecial paste:=xlvalues

Sheet object doesn't have PasteSpecial method.