Hello Hans,
As your rows could increase or decrease in number, then, if you are willing to insert at least two blank rows directly below the "End - roadmap:" rows and leave them there permanently, we could do the copy/paste using the CurrentRegion method:-
Using the CurrentRegion method, the data set needs to be bounded by at least one blank row and one blank column hence any text below the data set will be excluded from the copy/paste. This can be included in the code if you'd prefer.
I hope that this helps.
Cheerio,
vcoolio.
Bookmarks