Posts: n/a

Speed up macro

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date macro	Hiking	Excel Discussion (Misc queries)	9	February 3rd 05 12:40 AM
Can't get simple macro to run	Abi	Excel Worksheet Functions	5	January 12th 05 07:37 PM
Help with macro formula and variable	Huge project	Excel Worksheet Functions	0	December 28th 04 01:27 AM
Macro and If Statement	SATB	Excel Discussion (Misc queries)	2	December 3rd 04 04:46 PM
Macro Formula revision?	Mark	Excel Worksheet Functions	1	November 28th 04 01:43 AM

All times are GMT +1. The time now is 03:34 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us