Hi, I need some guidance on writing vba code on this area. How do I write a code whereby everytime the result is out, or shall I put it, when a loop result is out, it will put the result on a new worksheet instead on the current worksheet? Thanks and we are talking about MS Excel XP. Forrest Gump once say this to me, "Life is just like a box of chocolate, you never know what you are going to get!" but Thomas just replied recently, "Its True that life sometime can be like a box of chocolate but you will know what you are going to get till you visit the dentist!" Best and regards, Thomas Nathan Chan Webpage: http://www.heartwarmers4u.com/members/?thomas ICQ: 70375853 MSN Messager: thomasnathan2001@xxxxxxxxxxx -- Outgoing mail is certified Virus Free. Checked by AVG Anti-Virus (http://www.grisoft.com). Version: 7.0.185 / Virus Database: 260.1.6 - Release Date: 9/10/2003 ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in the subject line. Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************