Re: Detect if text is too long to fit in a cell

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thanks !

"Helmut Weber" wrote:

Hi Ludo,

see above the thread
"How do I tell if text fits into a fixed-width table cell"

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"

.

Relevant Pages

  • RE: Macro for wrapping text
    ... If we have rows of standard width, it is easy to determine if the text fits ... neatly in that cell or if it "spills over" into its right-most neighbor. ... Sub Macro1() ...
    (microsoft.public.excel.programming)
  • RE: Lines in cell?
    ... how many lines there are in a cell. ... > the row's height to a value resulting from the font size ... > from misusing Excel as a word-processor. ... > Helmut Weber, MVP WordVBA ...
    (microsoft.public.excel.programming)
  • Re: Print-To-File Problem
    ... fonts different sizes, proportional fonts, and all that stuff. ... So what fits ... in a cell in the sheet doesn't necessarily fit in plain text. ... Instead of printing to a text file, see if a prn file will work for you. ...
    (microsoft.public.excel.misc)
  • Re: Word vba return background shading value of cell
    ... You put your finger on the answer there, the background colour is a negative ... all 50 tables in the document, row by row, cell by cell and check each one. ... "Helmut Weber" wrote: ...
    (microsoft.public.word.vba.general)
  • Column Autofit
    ... Is it possible to change the setting for column autofit, ... fits the column to the cell with the greatest amount of text, ... column based on a cell with 10 characters. ...
    (microsoft.public.excel.misc)