Hi
saving the file should do the trick in nearly all cases (either VBA or
manually)

--
Regards
Frank Kabel
Frankfurt, Germany


Steve W wrote:
Hi,

If you press CTRL+End the cursor goes to the last cell in the
worksheet. You can also find the same cell in VBA using
SpecialCells(xlCellTypeLastCell)

When you delete contents of cells or whole rows/columns, the address
of the last cell doesn't change immediately, but it will recalculate
it automatically - eventually.

My question is, how can I speed up this recalculation process, or
cause it to re-find the real last cell right away? And is there a
method I can use in VBA and directly in the spreadsheet?

By the way, this applies to Excel 2000 and 2002, maybe others as
well.

Thanks in advance for your help!

S