How to check if cell contents overflow.

  • Thread starter Thread starter Alan Savage
  • Start date Start date
A

Alan Savage

Hi,

Does anyone know how to find out if the contents of a cell in a Excel
Worksheet overflow in the cell? Using string length does not work ideally as
some characters take up more room than others.

TIA

Alan
 
If it is the longest string in the column.
record the column width, then autofit the column - record the width, then
restore the old width. Compare the old width to the autofit width. It the
autofit width is larger.

Otherwise, you might have to create a dummy sheet. Copy over the cell and
perform the above test, then delete the sheet. Beyond that, I think you
would need to get into some heavy API work.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

splitting text in cell - row and column operations 6
Column Cell character number checking 4
Autofit rows where a cell contains results of formula 1
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Copying cell text to clipboard (using Putinclipboard) 2
Macro to delete cell contents EXCEPT for last 5 characters 1
Stack overflow exception, when chart is selected 1
VBA code to delete cell contents 5

Back
Top