ExcelBanter - View Single Post

[email protected]

On Fri, 24 Dec 2010 15:49:20 -0500, wrote:

Using Excel 2003, I have a workbook with a single sheet. A single cell on
that sheet is a named range with name "bbb".
-- Snip --

I started noticing other odd things happening with cells in that column.
The value in the cell was an integer and the column format was "General" so
that wasn't the problem.

Cells in other columns were OK and the code that I said was not working did
work for cells in other columns. I have no idea what was going on.

The fix: Delete the offending column and insert a new one and paste the
values into it.

Thanks for your replies.