Hi Herbert,

Many thanks, this looks like exactly what I need!

I suppose I can copy my date into your sheet and then use it.

There is only one thing as I get an error message:

Run-time error "9" :

Subscript out of range

"Herbert Seidenberg" wrote:

Thanks again

Martijn

Excel 2007
Transpose with macro
http://c0718892.cdn.cloudfiles.racks.../03_04_10.xlsm
.