David,
Thanks for ur help, Its working. But it also is creating empty ro
after each iteration. I guess because we gave the incriment a= a+1.
So I need to insert a code to delete empty rows. How would I do that?
Sazi

--
Message posted from http://www.ExcelForum.com