last cell stays the same

[Hans]

The last cell in my spreadsheet (K64) is a few rows under
the last cell with Text. However, when I delete the rows
between these two and press Ctrl+End, the last cell is
still K64.

This cell is not used in any name of print ranges and I
wondered why its position does not change.

Any ideas?

hans

 

[DNF Karran]

xl doesn't reset the size of the spreadsheet unless you delete the row
then click save

 

[Ron de Bruin]

Hi Hans

After you delete the rows you must save the file
before the usedrange will reset

Check out Debra's page about it
http://www.contextures.com/xlfaqApp.html#Unused

 

[Frank Kabel]

Hi
have a look at
http://www.contextures.com/xlfaqApp.html#Unused

 

[Hans]

Thanks for all the replies. Saving the files makes the
difference.

Hans

-----Original Message-----
Hi Hans

After you delete the rows you must save the file
before the usedrange will reset

Check out Debra's page about it
http://www.contextures.com/xlfaqApp.html#Unused


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Hans" <[email protected]> wrote in

message news:[email protected]...