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