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

in article
, Dave O at
wrote on 9/5/08 1:06 PM:

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.

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

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
_______


"Dave O" wrote in message
...


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

You could just autofit when you open the worksbook.

Columns("A:IV").AutoFit

In workbook_open or workbook_sheetactivate


Gord Dibben MS Excel MVP

On Fri, 5 Sep 2008 11:09:59 -0700 (PDT), Dave O wrote:



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