You need to reset the used range:

http://contextures.com/xlfaqApp.html#Unused

--
Biff
Microsoft Excel MVP


"silverfox52" wrote in message
...
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.