I am collecting cells from a worksheet into a row. Each time I run a macro I
want this row of cells to be copied
to the bottom of another range. This range is increasing in size as new rows
are added.

Whats the best way to programaticcally do this? I have tried to use to use
the End(xlDown)-method, but I wonder if there are better methods to do this?

Thanks

Torstein S. Johnsen