Speed up macro

R

rn

Hi

I am running a macro that copies a range from an open
workbook and paste it to another open one. When I run
the macro without vlookup function (in about 1000 cells
on the paste sheet the macro completes instantly, but
with it takes much longer. Is there any way I can speed
up the macro without sacrificing what the function of the
vlookup?

Thanks.
 
B

Bob Phillips

It would help to see the code, but at the very least, pre-pend the code with

Application.DisplayAlerts = False
Application.Calculation = xlCalculateManual

and appened this

Application.Calculation = xlCalculateAutomatic
Application.DisplayAlerts = True

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
R

rn

Hi Thanks a lot for the suggestions. I appended my code
but I was hoping it would run much faster. The problem
does not seem to be with the code but with the vlookup
function. When I run the macro but deleting the vlookup
fuction it completes nearly as fast as just a simple copy
and paste.
 
B

Bob Phillips

The time is probably taken by al the VLOOKUPs taking time to resolve. If the
suggestions don't improve it, then because it is just a paste job, then
there is probably no savings that can be made.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top