That's my problem. There is no flag. The only way I can identify what the last row is to go to the beginning of the cell, hold down the <shift> <end> and then arrow downn key. That will bring me to the last row, but how do you save that reference and incorporate it into the macro autofill range?