Unfortunately the error  message is correct. You can´t Copy-Paste multiple
selections.

I think you need to select each part and copy  it seperately

Is there anything unique in the column headers you can search for so you can
select each column in turn?

: Unfortunately the error  message is correct. You can't
: Copy-Paste multiple selections.
:
: I think you need to select each part and copy  it
: seperately

If you know the destination to be pasted, you could use
the Areas property of the range  to step through the
collection of areas it returns.

there are unique headers in the columns, and they (and the data) are
derived from a pivot table in a different worksheet.

(though some of the rows  are hidden as well).

I'm still pondering how best to do this, the process will only need to
be run once a month, over 15 to 20 repititions, so I might settle for
a CPU-intensive solution and run it over a weekend.

Not ideal, but will do as a kludge while I investigate something more
elegant.

I'll post an update once I've decided upon a solution.

I think I've got it to work ok now.

I'm just making a copy  of the entire worksheet into another workbook,
then renaming it and then using the ActiveWorkbook.BreakLink method to
generate the required values, leaving the formatting untouched.