Another solution might be to read the data into a workbook for which you can apply an autofit, and then read from this intermediate file the row height info into your collector workbook.

Dear friend, i do have a link between workbooks, but if i apply autofit to the cell containing the link to the source workbook, the height of the row will always be 15, no matter how long is the text.
I am working to a solution which counts characters in text : =LEN(A1), and to set the row height depending on this count. At first evaluation, looks like this method does not need the source workbook to be open...
Thanks again for your time gjcase, i will let you know if i find an acceptable solution, and please let me know if you have a better way

Catalin:

See the attached files. I have a source file, Book3.xlsm, an intermediate file, Intermediate.xlsm, which reads the data from the source, runs an autofit, and copies to the third file, collector.xlsm. See if this does what you are after.

Attached Files

	Book3.xlsm (9.0 KB, 14 views)
	Intermediate.xlsm (20.7 KB, 14 views)
	collector.xlsm (8.3 KB, 15 views)

Yes, gjcase, this is exactly what i need, only the intermediate is unnecessary, i will adjust the macro to copy directly from book 3 in collector.
Great solution, gjcase, thanks a lot.