I am using Excel 2003. When I run a macro that clears a number of named ranges I receive this error message "Excel cannot complete this task with available resources". If anyone has any ideas it would be greatly appreciated. Help Me!