This is where the Selection.End(xldown).Select comes in? You have selected a
specific number of columns, and with end down you are selecting the number of
used rows, down to the last used one.

Unless you have empty rows in between your range, of course, in which case
you will have to get rid of those first.

" wrote:

This would work but I have an a variable number of rows that i'm trying
to copy.