Re: $$Excel-Macros$$ Need help on keeping copy-paste simpler

2015-09-12 Thread ashish koul
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

Re: $$Excel-Macros$$ Need help on keeping copy-paste simpler

2015-09-12 Thread Isabel Cristina Ortiz
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

Re: $$Excel-Macros$$ Need help on keeping copy-paste simpler

2015-09-12 Thread Ricardo®
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