Re: $$Excel-Macros$$ How to use VLOOKUP formula using Array code.

2016-05-09 Thread karthik kumar
> *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John

Re: $$Excel-Macros$$ Applying formulas in large number of rows using VBA

2016-04-27 Thread karthik kumar
of rows if you ask me > > To speed up the code, you can set Application.screenupdating to false and > probably not use a loop and consider some other options, > > Would you mind posting your current code, so we can take it from there > > On Tue, Apr 26, 2016 at 11:17 AM, karthik kumar

$$Excel-Macros$$ Applying formulas in large number of rows using VBA

2016-04-26 Thread karthik kumar
Hi All, I need to keep formula as Vlookup in approximately 50,000 rows using VBA code. I have tried with many code. However, it resulted the excel to slow and take so much time to give output. Please suggest me to overcome this issue. Thank you, Regards, Karthikumar -- Are you =EXP(E:RT)