I have an application that allows the user to insert 10 rows at a time. The 10 rows get inserted into 213 ranges and then a formula in each range gets copied down the inserted rows. When I change it to allow the user to insert 100 rows at a time instead of the 10 rows, I get an error message saying "Excel cannot complete the task with available resources. Choose less data or close other applications.". This message appears when it's trying to copy the formula down the inserted rows. I only have one other application open and closing it doesn't make a difference. Is there something I should look for in the code?
Bookmarks