There is a workbook with a worksheet named "scratch" and an assortment of
other sheets. The sheet "scratch" is hidden, all cells locked, and
unprotected. It is always that way. It is used for all manner of things when
a convenient place to put data from other sheets is needed for whatever
reasons. Sorting, diddling, what have you.

From time to time in no predictable way, cell "A1" refuses to accept any
data of any kind. You can un-hide the sheet and type anything you want into
cell "A1". It disappears as soon as you press return or select another
cell. Gone, vanished, non-existent, not just invisible. Cleared out, empty.

If you delete all the cells, all the rows, all the columns, the behavior
persists. If you go through the entire litany of locking, unlocking,
protecting, untprotecting, etc ad nauseam it makes no difference.

If you set a breakpoint at the Change event for this sheet, type something
in the cell, and press return, the cell is empty at the break. This suggests
that Excel might have a problem.

The format, color, and all that sort of stuff is identical to the cells
around it which do no exhibit this bizarre behavior.

If you close the workbook and reopen it the cell starts acting normally.
Then at some indeterminate time later it starts with the inexplicable
behavior. During this time the sheet may have been cleared and/or all the
cells deleted any number of times and eclectic collections of stuff have
been placed on it, by pasting and/or simply setting values. None of the
stuff put there is abnormal in any way. Just all of sudden this cell refuses
to contain anything.

It may well be something I'm doing but I haven't a clue just what it might
be.

--
Terry

"I said I never had much use for one,
I never said I didn't know how to use one."
M. Quigley