Shila, First off you are very welcome. It helps me learn coding better to help when I can. The finalrow is where the data will never go past. The reason I set this up is because in Excel 2003 (I have not tested it in newer version) when you delete huge sets of data it has a tendency to move the file size up. I had one file that went from 23kb all the way to 23 mbs! This may be just with formatting but I wanted to make sure. You could leave it at 30,000 and watch if the file size goes way up. If it dosnt then kewl. But if it does you have the ability to control it with this variable.