Dear Sir,

thanks for showing the interest in my problem

Excel2002 version

thanks
hardeep

Shane Devenshire wrote:
Hi,

You are probably not getting an answer because something is missing in your
question. There is no problem copying a range, some cells of which are
merged and some cells of which are not merged.

The problem arises if there are merged cells in the destination sheet/range.
Also, there may be a version issue, so tell us what version of Excel you are
using.

Cheers,
Shane

Dear sir,

[quoted text clipped - 13 lines]

Hardeep kanwar

--
Message posted via http://www.officekb.com