Hi guys!!
I've searched a lot couldn't find it anywhere

Is there any possible way to copy values from a range
and paste with same data, same format and same merged cells
ie. if first two cells of the copied row are merged then upon pasting data
the first two cells of the target location should get merged.

In other words i want to emulate FORMAT PAINTER. Help!!!
As quickly as possible.Thnx in advance