Hi,
I would create an array (if the datatypes are all the same - of the
required datatype or else of type variant). I would copy data from a row into
the array members and then use that to copy into the destination sheet. In
case multiple rows are involved, could create an arry of arrays 9 two
dimensionsal).

In case the number of rows is very large, it may be worth copying the
entire sheet to a new sheet, deleting the unwanted columns and then copying
and pasting the rows to get them in the right order.

Jai

" wrote:

Dthmtlgod:
I couldnt sleep last night and your question got me thinking so I
put together a Macro for you that will do the trick. Trouble is it is
too lengthy to copy here in a format that will be easily legible. If
you want me to send it to you, E-mail me @ and I'll
snap it to you as an attatchment.