Adaptive cell range

Hey,

I'm trying to get a cell range to increase to match my data size, every time the macro is ran.

Basically, I have a range ("B2:K20") that I'm copying and pasting over one column, to ("C2:L20").

Now, the next time I run the macro to copy and paste this range, the range I want to capture is 1 column larger. So the next range, after copying and pasting the first range to the right, would be ("B2:L20").

How can I make my range equal the number of columns I want to capture? It might help to add that there is nothing to the right of the cell range I'm trying to target.

Thanks in advance

Hey Deep.

This might help make my problem more clear.

Thanks for your patience.