Can u pls share a sample file
On Sep 12, 2015 9:38 PM, "Isabel Cristina Ortiz" wrote:
> Thank you Basole for your message!
> I have been already using your recommendation on my code, but it still
> takes a lot of memory.
>
> Regards,
> Isabel
>
>
>
> On Saturday, September 12, 2015 at 9:20:05 AM
Thank you Basole for your message!
I have been already using your recommendation on my code, but it still
takes a lot of memory.
Regards,
Isabel
On Saturday, September 12, 2015 at 9:20:05 AM UTC-5, Basole wrote:
>
> Hi isabel, try using "Application.ScreenUpdating = False" To Turn Off at
> th
Hi isabel, try using "Application.ScreenUpdating = False" To Turn Off at
the start of code. and "Application.Calculation = xlCalculationManual" To
turn off the automatic calculation
at the beginning of the code
see example:
Dim u As Integer, v As Integer
u = Range("Months").Value - 1
Application.S