View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default largest right and bottom cell used (size of spreadsheet)

Generally, just delete all unused rows and columns below and to the right of
the true used range, then save the workbook. That should reset the Last Used
Cell.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"John Keith" wrote:

Is there something in excell that remembers that largest right and
largest bottom cell that has been used? And if so, is there a way to
reset that memory if the spreadhseet has since been reduced in size?

Thanks


John Keith