number of sub lines a text will occupy before being copied

Hi!

I have a range of text cells in sheet 1 intended to be copied to sheet 2 with the automatic word wrap option

how to calculate the number of sub lines a text will occupy before being copied to sheet 2 ?

i use this number for auto layout of sheet2

thanks

Lets say you want to copy range("A1:A5") to the second sheet. This is an example.

Please Login or Register  to view this content.

Thanks for the answer but that's not what I'm looking for
I am looking for how the wraptext works to calculate the height of the line that the system of excel puts
sorry if I was not clear on the subject