Hi Myriam

You can use Pastespecial
It have a transpose argument

See the VBA help for this
If you need more help post back



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Myriam" wrote in message ...
I am using Ron's code to retrieve data from closed workbooks.
The code works wonderful but I need to transpose the output on the
destination book because I am copying a complete column from each workbook
and I want to have the name of the book as the title.
Instead of
e.g. Range1 Book1
Range2 Book2
Range3 Book3
I need it:
Book1................ Book2 ................. Book3
Range1(ColumnC) Range2(ColumnC) Range3(ColumnC) ETC.
Thanks in advance for the help!