Technically, can anyone explain to me why Cells.Find() is so much faster than a loop?

  • Thread starter Thread starter Will
  • Start date Start date
W

Will

Can someone please explain to me why it is so much faster to use the
built in application functions, particularly for searching, when
programming an Excel Macro than creating a loop? Thanks for your time.
 
Built in functions are compiled executables where as VBA is not. Additionally
VB/VBA is not the most efficient language when executed where are as the
built in functions are probably using C/C++ or something similar.
 
Built in functions are compiled executables where as VBA is not. Additionally
VB/VBA is not the most efficient language when executed where are as the
built in functions are probably using C/C++ or something similar.
Click to expand...

I'm not very versed in computer programming, but how are compiled
executables in dealing with system resources? What about a compiled
executable makes it faster other than running through a VBA compiler
like a hand-made macro?
 
Check your other post.
Can someone please explain to me why it is so much faster to use the
built in application functions, particularly for searching, when
programming an Excel Macro than creating a loop? Thanks for your time.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can anyone explain to me why built in Cells.Find() is faster than a loop? 3
Looping Macro 3
Cells.Find bug that's very strange 3
Cells.Find Bug that's very strange 3
For Loop - If / Or 2
How to Loop 6
using a formula for a column vs. looping over each row - speed difference? 4
StringBuilder much much faster and better than String forconcatenation !!! 32

Back
Top