I'm trying to figure out how to code a process that tells excel to wait for data to be inserted into sheet1 starting in 'A5'. before running a macro. This is part of an export from a Lotus Notes database. I've tried a loop coupled with a wait but it won't allow the insert or paste to take place while its running. The code I have now runs when the spreadsheet is opened. Any suggestions?