View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Select range of cells from A1 to last cell with data?

that indicates to me the cells with borders also have somethign in them. Most
likely a null set. Ifyou highlight from last actual data row to bottom of
your blank cset and click the delete button, you will be rid of them.

"Bob Arnett" wrote:

I'm trying to select all cells from A1 to the last cell that has data. Using
Shift-Ctrl-End selects all cells including ones that just have borders and no
data. Is there a way to do this?