Type Mismatch Errors...:Val() function

I'm terrible with this error...

I have an Variant array named Calcs3(), and I want to do this:

Please Login or Register  to view this content.

Calcs4 is also declared as a Variant array.

It's my understanding that the Val() function takes a string and reads all of the numbers out of it. However, I keep getting a type mismatch error when I try to take Val("3.36%") or something like that. It just won't do it.

All I want is 0.0336 to go into Calcs4(i,j).

Thanks

Looks like Val doesn't like converting strings with %. You might need to do this

Please Login or Register  to view this content.

Ah, that little check made things run like a dream. Many thanks, shg!

You're very welcome.