Is there a cell or column property that indicates ##### displayed?

[Dave O]

When then width of a number is greater than the display capability of
a cell, that cell shows #####. Is there a cell or column property
associated with this?

Thanks,
Dave O
Eschew obfuscation

 

[Jim May]

(e-mail address removed), Dave O at

When then width of a number is greater than the display capability of
a cell, that cell shows #####. Is there a cell or column property
associated with this?

Thanks,
Dave O
Eschew obfuscation

Go to the right-border in the Column Header of your ######## column
And double-click on it. This should expand the column width to accommodate
the necessary data.

 

[Dave O]

Go to the right-border in the Column Header of your ######## column
And double-click on it.  This should expand the column width to accommodate
the necessary data.

Thanks, Jim- what I'm trying to determine is if there is a way to
detect this using VBA, so I can write a routine to widen columns. The
spreadsheet is locked to the users, so they won't be able to double
click on the column header, but I'd like them to be able to view their
data.

Dave O
Eschew obfuscation

 

[Jon Peltier]

You could just use ActiveSheet.UsedRange.EntireColumn.Autofit.

You can see if a cell displays all # characters something like this:

With Range("A1")
If Len(.Text) > 0 And Len(Replace(.Text,"#","")) = 0 Then
' cell contains all # characters
End If
End With

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

Go to the right-border in the Column Header of your ######## column
And double-click on it. This should expand the column width to accommodate
the necessary data.

Thanks, Jim- what I'm trying to determine is if there is a way to
detect this using VBA, so I can write a routine to widen columns. The
spreadsheet is locked to the users, so they won't be able to double
click on the column header, but I'd like them to be able to view their
data.

Dave O
Eschew obfuscation

 

[Gord Dibben]

You could just autofit when you open the worksbook.

Columns("A:IV").AutoFit

In workbook_open or workbook_sheetactivate


Gord Dibben MS Excel MVP