See your other thread
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Myriam" wrote in message ...
I am using Ron's code to retrieve data from closed workbooks.
How can I transpose the output in the destination workbook?
e.g., Data1 Book 1
Data2 Book 2