| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Technically, can anyone explain to me why Cells.Find() is so much faster than a loop?
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Technically, can anyone explain to me why Cells.Find() is so much
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. -- HTH... Jim Thomlinson "Will" wrote: 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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Technically, can anyone explain to me why Cells.Find() is so much
On Nov 6, 1:39 pm, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com wrote: 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. -- HTH... Jim Thomlinson "Will" wrote: 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 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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Technically, can anyone explain to me why Cells.Find() is so muchfaster than a loop?
Check your other post.
Will wrote: 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. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| For Next loop faster with counter after Next? | Excel Programming | |||
| Faster way to loop through two ranges | Excel Programming | |||
| Is there a faster loop than this | Excel Programming | |||
| VBA | Individual Iterations faster than Loop Statement | Excel Programming | |||
| Faster For-Next Loop? | Excel Programming | |||
![Will[_13_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
