
#1
Aug509, 04:38 PM

P: 3,012

I keep getting this error when I run this code. Nothing is highlighted..and VBA help is not working out for me.
It just started when I added the for loop in bold below:
Thanks 



#2
Aug509, 07:06 PM

P: 208

I have not used any VB in a while but I would say on the 3rd line after the for it might be trying to concantenate or add the j=j+1 to the element of the array.




#3
Aug509, 07:53 PM

P: 735

I agree with Ronnin. I would do it this way:




#4
Aug509, 08:20 PM

P: 735

Excel VBA:: Run Time Error '13' Type MisMatch??
I noticed that you redim preserve the array on each pass of the loop. Your code would run faster if you precount the number of elements required beforehand and redim the new array before starting the loop.




#5
Aug1909, 11:01 AM

P: 1

I get the same error when I run the following code. If I comment out the lines in bold, the error goes away, but then the code doesn't do what I want! Any suggestions? Thanks in advance for any help you can give me. I'm no VBA expert and I'm hoping I'm just missing something that's obvious to others.




#6
Sep709, 06:54 PM

P: 322

In the highlighted code above, you are assuming that the value in the score variable is a number, whereas it is probably a string. You may need to convert it.




#7
Dec309, 06:56 AM

P: 1




Register to reply 
Related Discussions  
excel, error of trend line?  Math & Science Software  2  
Error Analysis On Excel Questions  Introductory Physics Homework  2  
Expectations for Type I Error  Set Theory, Logic, Probability, Statistics  4  
Parallax error  what type of error is it?  General Physics  5  
Excel help with error bar formula  Set Theory, Logic, Probability, Statistics  1 