Gustav Brock
Gustav at cactus.dk
Fri Oct 28 11:26:27 CDT 2005
Hi Marty Thanks, I'll check that site out. /gustav >>> martyconnelly at shaw.ca 28-10-2005 18:04:41 >>> Some of these replacements for VB intrinsic fumctions might speed things up. Make sure you read the accompaning notes before using some may require a TLB http://www.xbeat.net/vbspeed/index.htm But it sounds like you are using mostly math functions. Trig functions can be enhanced from basic vba calls but would require C. Sometimes you can get a bit more speed from multidimensional arrays by the order of looping on the indexes. For example you are not going to get much speed increase by using *0.5 instead of /2 maybe 1-2%