gt;
> *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 Wesl
Dear All,
I need to reconcile the two sheets having more than 1,50,000 rows. I used
following VBA code. however it is taking more than 30 minutes to give
output. Sometime it gets stuck when macro running.
Sub MakeFormulas()
Dim SourceLastRow As Long
Dim OutputLastRow As Long
Dim sourceSheet As
p 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 > wrote:
>
>> Hi All,
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)
