The Last Cell will grow as data is added to a spreadsheet. But will only
shrink, when the workbook is saved. So, even if you delete all the cells
below and to the right of your data, the last cell will not be updated until
you save your workbook.

HTH
Elkar


"silverfox52" wrote:

When I use "Go To", "Special", "Last cell" in my spread sheet, the cursor
goes many rows past the end of the data. ie. about 36 rows past the last data
row.

This is a problem because when I import this data into a blank Access table
all 43 rows are imported (36 are blank) and the import gives me an error
message.

I've tried deleting from the last data row +1 past the row of the "last
cell" but the last cell remains in the same relative location.