Hi Praveen,

You shouldn't use merged cells.
I also don't see the need for any vba or blank rows.
It looks like this data is from a pivot table?

Anyway, have a look at the attached file which I hope will help.


+-------------------------------------------------------------------+
|Filename: sample data2.xls |
|Download: http://www.thecodecage.com/forumz/attachment.php?attachmentid=623|
+-------------------------------------------------------------------+

--
Evolbob
------------------------------------------------------------------------
Evolbob's Profile: http://www.thecodecage.com/forumz/member.php?u=1980
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=206560

http://www.thecodecage.com/forumz