Yes, it was in the last column. Plus, it thinks the last cell is
L65535, and the last row of actual data is in cell L500.

No hidden rows or columns. I tried selecting all cells, copying, and
pasting into new workbook. Even after I did that, I could not reset the
UR. I tried selecting only my data and pasting into new workbook.
After I did this, I extended the used range by putting some value in a
cell far below my data. I tried to reset the UR here, and it worked.

So there is something special about those empty rows. I just can't
figure out what.


Peter T wrote:
Is the last cell in the last column? Any hidden rows/cols,
even within what you think should be the UR ?

Peter


-----Original Message-----
XL 2002

Yes i have tried saving, closing, reopening. No effect.

Any other idea?

.