rolling your own

[dcraig1]

grantx,

I don't know if there is some sort of profiler for Excel, but if you can get hold of one, it might be a big help in solving your Excel performance issues.

A profiler for a conventional programming language will show you which functions or pieces of code the application is spending most time in ie which bits of the code are consuming the most CPU cycles. (Some profilers - eg Java profilers also track memory use).

You can then examine the appropriate pieces of code (or in your case spreadsheet) to see if they can be better done using a faster algorithm or whatever. You might even find that some calculations are unnecessary or are being repeated unnecessarily.

 

[grantx]

Temptrader, Dcraig,

Excellent info and advice. I've printed both replies for reference.

There is a US programme which compiles Excel sheets into one of the C language codes. The problem is it doesn't recognise VBA so its use is limited.

In due course, writing a dedicated programme (someone qualified can do that) seems the solution.

Thank you, gentlemen.

Grant.