Detect if row height is fit to the contents of the cell or not

[YasserKhalil]

Hello experts
Is there UDF function that detects the contents of the cell and see if it is fit to the row height or not?
Thanks advanced for help

[PCI]

What do you mean by " if it is fit to the row height or not"
Can you example with correct and not correct display

[YasserKhalil]

What do you mean by " if it is fit to the row height or not"
Can you example with correct and not correct display

Thanks a lot for reply
Have a look at this sample file

[PCI]

Not easy to evaluate what is the row size versus the contain.
What do you want to do after to diagnostic a bad size, is it to adjust the size of the row?

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

[YasserKhalil]

Thanks a lot for replies
In fact I do sort task for range (with different row heights ..)
After sort I got unfit row heights so I am seeking for a way to keep the row height of the same cell before sort
For example : if row 9 has 21 height and after sort row 9 became row 3 (now row 3 is not the same height) >> I need to keep the row height which is here 21 .. so row number 3 would be the same row height

Please have a look at this sample to illustrate the problem (sort the range A1:B4 by column B)
I need to keep the row height of cell after sort

[JOHN H. DAVIS]

Probably not the best solution but you could use an inserted helper column to record your row height prior to sorting.

Please Login or Register  to view this content.

[YasserKhalil]

Thanks a lot Mr. John for the idea
In fact I had the same idea but using loops with large amounts of data is a disaster ..
and this is the problem for me in most issues .. so if there is a method using vba arrays, I think it would be very useful
Thank you very much