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
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
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
What do you mean by " if it is fit to the row height or not"
Can you example with correct and not correct display
- Battle without fear gives no glory - Just try
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?
Does this help?
Please Login or Register to view this content.
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
Last edited by YasserKhalil; 05-25-2016 at 03:15 PM.
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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks