I'm terrible with this error...
I have an Variant array named Calcs3(), and I want to do this:
Calcs4 is also declared as a Variant array.Calcs4(i,j) = Val(Calcs3(i,j))
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
Bookmarks