Hi Peter, Thanks for replying. Your macro pretty much doing what i
need. Just another question that in Word Document Object which i have
on my excel sheet i have some coloured text and some text is in bold
and some text is in normal. How can i get same formated text on my
excel sheet. At the moment i getting result on a message box but it
would be greate if i get result on sheet and also in same format as it
appeares in word document object. Please help