Performance becomes an issue with large datasets too. A poorly written macro can bog down Excel and take forever to complete, ...

Fix Runtime error 7 Out of memory when the Microsoft VBA tries to execute an automated task in Excel by following these suggestions.

If keyboard shortcuts are not working in Excel first check Macro settings or disable Transition navigation keys and see. More suggestions here.