Understand, you would need a button or something. A user has to initiate any sort of CHANGES to a sheet, a program cannot. You would need to place a button on the sheet, and press it after all rows have been changed. Almost like an "end of Data entry Process". Make sense?