I am using VBA to find and replace currency formats across all worksheets based on currency selection in a particular cell. The code works just fine functionally, but I often run into an error - "There is not enough memory to complete this operation. Try using less data or closing other applications."
I am new to VBA and I believe this is because my code isn't optimal in its usage of memory. Below is the code for the whole function. The yellow highlighted area is where the VBA stops executing and throws the memory error. I will be very thankful for a solution!
Update - I have attached a sample workbook with the current code and the objective explained within.
Please note that while this sample workbook only handles 2 currencies in 2 worksheets, I need this code to optimally work over 5 data-intensive tabs with 10+ currencies
Problem - In the actual workbook, I often run into a memory error as described previously.
Request Assistance in - Please help me optimize the code in this attached example workbook to utilize less memory so that the memory error does not show up in my actual workbook.
Bookmarks