I'm getting the error "Excel cannot complete this task with available
resources. Choose less data or close other applications." trying to
insert a column in Excel 2007. Works fine in Excel 2003 on the same
worksheet.

The worksheet has 59,604 rows and 16 columns. I have 2GB of RAM on
this computer.

The error happens on this line:

<whole-column range object.Insert Shift:=xlToRight

Again, it works fine in Excel 2003 (SP2), with the same data on the
same computer.

I tried rebooting, didn't help.


Is Excel 2007 more limited than Excel 2003 in the amount of data it
can move around?

I guess I'm probably going to have to do this in pieces. Any other
suggestions?


Thanks,

Greg