Thanks Bob [:)]
Rick i have few queries now . .just like exception handling .. like
take a look at the attachement now and focus on colourd part , here
data is sorted as it was but block contains just one value .. it should
copy it as it is ... getting me .. take a look i hope u ll get where i m
stuck now
Regards


+-------------------------------------------------------------------+
|Filename: Test1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4757 |
+-------------------------------------------------------------------+

--
Dastard
------------------------------------------------------------------------
Dastard's Profile: http://www.excelforum.com/member.php...o&userid=34406
View this thread: http://www.excelforum.com/showthread...hreadid=541843