Why would rows to the right of cell BB get deleted? Did you mean to the left?

There is no information in A1:BB1119 that I need so I am trying to delete
that area. Is there a limit to how much can be deleted in a macro? The
sheet is a 1.9 mb file when removed from the workbook. When I delete all of
the information on the sheet manually, then create the macro to remove
A1:BB1119 it will work.
--
Mary Frances


"Joel" wrote:

Excel is making sure you don't incorrectly delete additional information you
still need. If excel did what youi want then data at higher rows above 1119
would also get deleted and data to the right of cell BB would get delete.

These two additional areas would get deleted.
A1120:BB65535
BC1:IV1119

"Mary Frances" wrote:

I have a 9 mb file that I want to create a macro that will copy/paste/new
workbook/creat a copy for one of the sheets, then copy/paste values some of
the cells in the new workbook, then delete A1:BB1119. The macro I have
written should work, but does not. If I delete the rows and then the
columns, the rows will delete, but not the columns. If I delete the columns
first, the rows will not delete. I am thinking Excel may have a limit on how
many deletions it can do in a macro. Do you have any ideas on how I can
accomplish this task?
--
Mary Frances