Speed testing

[Jacob]

comparing Val() to CInt() (and others) is not really a good plan
Val is like the Variant of casting functions

Cint("AAA") = RTE13
Val("AAA") = 0

but yeah, i recommend to use proper casting functions for speed vs Val

also, i've noticed you guys like to use Parse$()
the $ is not needed because it indicates a string, Parse() is an array of Strings, no need to specific that its a string when it already knows...

For the CInt("AAA") = RTE13, couldn't you do

If IsNumeric("AAA") before your conversion?
If so, what's the speed difference between Val() and checking for isnumeric then converting?