Norman,

The VB Code didn't quite work.

The resulting sheet was close to what was expected. But I think the
error came down to my example above which didn't leave me room to
exactly show what was required in a google groups posting.

The resulting file gave the format:

Sheetname|F12|F13|F14|F15|F16|F17|F18|G13|G14|G15| G16

Is it Possible to output in this format?

Sheetname|F12|F13|G13|F14|G14|F15|G15 and so on t

F13 onwards would ideally allternate with it's corresponding G.

Cheers
Prometheus.