Hi Gabriel

See this page for a example
http://www.rondebruin.nl/copy3.htm#column

Note: you only have 256 columns



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


"Gabriel" wrote in message om...
Hi,

I want to copy the usedranges from many files into one excel file. I
want those usedranges to be appended to the last column and not to the
last row. I thought that this part would do it, but it doesn't

Destination:=TargetSht.Cells(1, Columns.Count).End(xlLeft).Offset(0,
1)

Can anyone help please ?
Thank you
Gabriel