Hi. I understand what the following line is for but can you just elaborate a bit, just need to understand it a bit more as I may need to change it

Range("A1", .Range("A" & Rows.Count).End(xlUp))

If I need it to stop when it encounters a particular piece of text for example 'End' and copy everything up to but not including the 'End'.

Thanks