Length of text within cells

[mdmackillop]

Is there a method of calculationg the length of a string of text in relation to a cell?
My workbook setup does not allow me to autofit rows, as it would upset printer output. I would like then, having typed in a string of text, that the length is split into suitable lengths, additional rows inserted to suit, and the text written in the appropriate cells.
I've done this before based on a set number of characters, looking for the previous space and so on, which works tolerably well, but is not very flexible. Any suggestions for a better approach?

[Zack Barresse]

MD,

The closest I think one can come to that would be expressed by Suat's recent entry to Aaron Blood's Challenge ... http://www.xl-logic.com/xl_files/cha..._detection.zip

Other than that, I'm not sure that there's a decent way to do this. Maybe checking pixel length using API..??

[Paleo]

Hi MD,

maybe you could use this:

Range("A1:IV65536").WrapText = True

[mdmackillop]

Hi Carlos,
I have to insert a footer/header every 45 rows when the document is printed with "Carry Forwards" etc, page numbering etc. If I wrap text, I'll need to start finding page lengths etc, which is a route I wish to avoid.

[Paleo]

Oh ok, well than the only thing I can imagine is to follow Zacks suggestion.

[mdmackillop]

Thanks Zack,

I've had a look at that, but it doesn't look like the way forward, but here's my solution to Aaron's problem (I've done a KB with it too)

Zip file revised; options added.

[Paleo]

Great Malcolm,


I will save it, who knows when I may need it.

[mdmackillop]

Update