Thanks, but how to I change the code so that the data is entered on the
first run and not the second. At the moment the for is coming up and I
enter the 3 peices of data, click ok and nothing is entered into the
spreadsheet. When I click yes to enter another record and enter the 3
peices of data it is added to the spreadsheet.

Why would it work on the second data entry but not the first?



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/