Delete...........do not clear contents...........all rows and columns below
and right of the actual range of data.

Then SAVE the workbook to reset the used range.

To do it with code See Debra Dalgleish's site.

http://www.contextures.on.ca/xlfaqApp.html#Unused


Gord Dibben MS Excel MVP

On Sun, 5 Oct 2008 20:40:00 -0700, lucy
wrote:

how do i mark the last used cell as page end, my spreadsheet goes down to row
26661 and across to BU. We are currently only up to line 3660 row Z