Catalin:



I'm confused. I assume you are reading data from other workbooks (vs worksheets, which would be contained within the same workbook, and therefore always accessible.) However, to read the data, you must have the source workbook open, and therefore you should be able to read the row height at the same time, correct?

I agree with Tony, a macro which opens each source, reads the data and rowheight, and writes that to the collector and then closes the source, would seem to be the way to go.

You are right, gjcase,
text data are in separate workbook.
But to read the data from that workbook, it is not necesary for that workbook to be opened.
Only the macro with User Defined Function looks like it is not working with the source workbook closed.
Excuse me for the confusion i created...
Looks like there is no other option but to open it so i can read the row height...
Thanks for advices, gjcase and Tony

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.