View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default a question about cell text wrap

The extent of Cell Wrapping is a function of the Cell ColumnWidth and most
of the Font properties. AFAIK there is not a function that provide the cell
wrapped rows. I suppose you could compute this by inspecting all the cell
properties and calculating it, but for non-fixed fonts that wouldn't be
possible.

Cheers
Nigel

"wcc" <wccpppATyahoo-NOSPAM-DOTcom wrote in message
...
Hi groups,

If a cellformat's WrapText property is True, can it be determined how many
lines of text are in that cell? And further, what is the content of each
line? Thanks very much for any suggestion,

wcc