View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
terry terry is offline
external usenet poster
 
Posts: 193
Default Determining the last row and column used on a sheet

This being the case, how does one "delete the last row, column entry" if a
cell was used erroneously? I keep getting a compatibilty error in 2007 from
a previous version, where the cell used was "outside" 255 X 65535.

"Maury Markowitz" wrote:

Be careful with UsedRange. The range inside gets expanded just by
talking to the cells even if there's nothing in it. I always use .Find
as a result.

Maury