View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RealGomer
 
Posts: n/a
Default cannot shift objects off sheet after using Subtotals

I have a spreadsheet that, after running Subtotals from the Data menu,
returns the error message "Cannot shift objects off sheet" when I try to
condense the spreadsheet. There are no comments on the spreadsheet. I
selected all cells and pressed "Delete". The susbtotal range is below any
text. After running Subtotals, there are a total of 2,374 roows. What gives?
--
I know enuff to be dangerous.