Lookup execution time

Hello All,

I'm wondering if anyone can help me out with the code below. When i run it it takes very very long time to run. i would appreicate your help. The data size is very large (more than 50k rows and over 24 clos.)

Please Login or Register  to view this content.

Hello Zade,

Please edit your post and wrap your code. If you don't your post will locked because of failure to observe the forum rules. Click the links below.
How to Wrap your code

Forum Rules
Sincerely,
Leith Ross

Thanks Leith,

Zade,

I've wrapped your code for you (rule 5). Please read the rules below as next time as Leith pointed out it may be locked or even deleted

VBA Noob