Thank you Logit,




What I was trying to explain in my example was that the numbers of blank cells above the cell with END will be of a random nature and copied rows may be inserted at any time.
To me it seems like the first time .End(xlup) is run it finds the cell below END. If the cell above END is blank, run again .End(xlup) to find the next last blank cell (in my example A27). The number of blank cells above END may very well be not consistent.