<hr>p.s. If you think right now 'yet one other guy reinventing the wheel, please feel free to post a link to a freeware code/add-in which adds this functionality to Access! <hr>What you are ignoring is the fact that Access is not a spreadsheet, and there is no real purpose in this kind of functionality in Access. Access records are not related to one another the way that rows in a spreadsheet are. If you explain *why* you're trying to do this, someone may very well be able to point you to a method that approximates that.