You are always writing into the range of A1-C1. You will have to change the ranges depending on the row you want to write to. However, it would be easier to either wirte to a CSV-file, then import that into Excel or really go the professional route and use a database like MS Access or any SQL server for this. This will give you the flexibility of using SQL queries to SELECT/INSER/UPDATE your records. Appropriate UDFs can be found in the UDF Forum.

[ 15. July 2003, 15:06: Message edited by: sealeopard ]
_________________________
There are two types of vessels, submarines and targets.