Another way to do it would be to use an advanced filter. This assumes you
worksheet is similar to a database and the first row has "column/field
headers"

You would write the headers in the order you want in the destination sheet
(with code of course), then use the advanced filter to populate them.

Post back if that sounds like something that would fit your needs.

--
Regards,
Tom Ogilvy


"Ivan Raiminius" wrote:

Hi Esther,

if you want to change order of columns, you have to rearange them after
copying, or to copy them one by one in desired order.

Regards,

Ivan