I'm terrible with this error...

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

Calcs4(i,j) = Val(Calcs3(i,j))
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