When I try to cut and insert 20,000 rows from one worksheet to another
worksheet that already has 50,000 rows I get the error "To prevent possible
loss of data, Excel cannot shift nonblank cells off of the worksheet." I
only see a total 65,536 rows in the worksheet - I thought Excel 2007
supported a million rows.