Forum Discussion
Excel cannot complete this task with available resources. Choose Less data or close others applicati
I developed a report for my business user. During the development I used Windows 64 bit and Excel 2013 64 bit version for developing marco. My code have some arrays and looping function. After finis...
Follow these links you may find a solution in them:
https://support.microsoft.com/en-us/help/2779852/how-to-troubleshoot-available-resources-errors-in-excel
https://support.microsoft.com/en-us/help/2655178/excel-cannot-complete-this-task-with-available-resources-error--excel
I think that your code may need some refinements and optimizations, try to explicitly declare all variables, set Option Explicit to On., use the appropriate data types and so on.
It's up to you and your experience as a VBA developer.
Thanks so much. I have tried Option Explicit, but I still got the same problem when I tested with 32-bit version.