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)


"rn" wrote in message
...
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.