Take a look at this thread for a possible solution... http://www.excelforum.com/excel-prog...te-a-cell.html