Hi All

I have written a couple of custom functions for use in Excel using VBA
Whilst the time taken to execute them individually is not awfully long
when I have reasonably extensive use of them in any workboo
particularly when the search array is reasonably big, say of the orde
of 2000 rows by 10 columns, there is a noticeable drop in th
recalculation time.

I am advised that this is more than likely due to the overhead of usin
VBA or the premium you pay for writing them in VBA (for the ease o
coding in VBA particularly in the handing of variant data types
against writing them in C++ or C for that matter.

If this is the case, I would like to rewrite these functions in C (
can program in C relatively OK).

I would need to read a range of cells from a worksheet and transfer th
cell contents in to an array of variants. I would now need to pass thi
array just created to a C function that I would call from another VB
custom function - the idea being to do the processing of data in
rather than in VBA with the called C function returning a doubl
values.

Any assistance shall be highly valued.


Best regards



Deepak Agarwa

--
Message posted from http://www.ExcelForum.com