|re: "i have some boxes which are merged..."|
What do you mean by "boxes"?
re: "can you make it to work with merget cells and to keep the same format of the cells like the ones from sheet1."
Obviously I can't see your spreadsheet from where I'm sitting, but when I run the code against my test data, it copies all formatting including merged cells (both horizontally and vertically merged), cells filled with colors, italics, bolds, underlined and different fonts and font sizes. In other words, it copies all formatting from Sheet1 to Sheet2.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.