I am trying to copy a selection and paste it into the rightmost empty column.

I am not sure how to do this without specifying a row/column number.

Currently I have

Selection.Resize(3).Copy

Where do I go from here?

I will probably have to make use of- .end(xlToLeft).column+1

Thank you