N
Neal Zimm
HI all,
The worksheets in my app must be printed on paper about 7 inches wide in a
font size of at least 18 or 20 to be read in very dim lighting. Column
widths are fixed.
If a macro generated text string does not 'fit' into the designated cells
in 1 row, I use more than 1 row to hold the text after spliting it into
'words'.
I'm trying to AVOID building a function to return the width of a character
string in inches, for a few font sizes and 1 to 3 font names.
.Shrinktofit on its own doesn't seem to help.
1. I can't find a way to test, If OneCell.Shrinktofit = true then Did
Excel actually shrink the cell contents ? This would help.
2. Is a call available to MSword that returns the width in inches of a
string, where its input is the font name and size of the characters? (It's
gotta be there, but is it available to mortals? I've also posted this on the
Word bulletin board.)
3. What might other 'stuff' be that I might be able to use?
Thanks.
The worksheets in my app must be printed on paper about 7 inches wide in a
font size of at least 18 or 20 to be read in very dim lighting. Column
widths are fixed.
If a macro generated text string does not 'fit' into the designated cells
in 1 row, I use more than 1 row to hold the text after spliting it into
'words'.
I'm trying to AVOID building a function to return the width of a character
string in inches, for a few font sizes and 1 to 3 font names.
.Shrinktofit on its own doesn't seem to help.
1. I can't find a way to test, If OneCell.Shrinktofit = true then Did
Excel actually shrink the cell contents ? This would help.
2. Is a call available to MSword that returns the width in inches of a
string, where its input is the font name and size of the characters? (It's
gotta be there, but is it available to mortals? I've also posted this on the
Word bulletin board.)
3. What might other 'stuff' be that I might be able to use?
Thanks.