Code for a defined range which has been added to

I have some code which works on a defined range (and it's just one column, but I don't want the top cell of the column included in the process, so I can't just use 'Column' in my commands).
But the range constantly has new data being inserted into it, making it larger.
I don't want to keep adapting the defined range in the code itself.

So, is there code which automatically selects the full range of data in one column, starting from the second row, so that I can then paste it to another section of the sheet?

It currently looks like this. I'm still very basic in what I do, so apologies:

Please Login or Register  to view this content.

Hi Tishmimi,

Not quite sure what you want - try something like this:

Please Login or Register  to view this content.