Data of array

[maroon1]

Hi everybody!

I'm a beginner in VBA and need your help please!!
I have a problem with a code I wrote to apply an operation on an array. I need to take the values of the sheet "TRI" from the row 2 and column 3 to the end. Divide them by the values of cells (i, 2). Then past values in the sheet ("typology"). I'm searching the problem from long time but I can't see what is wrong! It bugs on the red line:

This is the code :

Please Login or Register  to view this content.

Thank you very much if you can explain me what is wrong!

[shirleyxls]

Can't see which line is failing.

Could you attach a small sample workbook with desensitized data so that we can take a look.

Thanks

[maroon1]

Hi shirleyxls!

Thank you for your answer!
I put an example of file in attachment to see what I need!

[scottiex]

What error does it give you? and is it on the first line or is it on another line?

At a guess.... I think maybe it is type mismatch 13 and your data is not in the right format (i.e. not entirely integers).

[maroon1]

On this line

Please Login or Register  to view this content.

!
Does it work for you? I don't know what type mismatch 13?

[scottiex]

Your 3rd column has "-" in it and that is not an integer so you cant divide it by 1.2. Which causes a type 13 error
*guessed it!!*

[maroon1]

Does it mean I have to replace " - " by " 0 " in the entire table?

[scottiex]

Yes, or maybe see if this has the desired effect

Please Login or Register  to view this content.

[bakerman2]

Please Login or Register  to view this content.

In the second part where you make the calculation you refer to the above, but this sheet is empty. In fact you are trying to make calculations with no values.

[maroon1]

No it's ok, what scottiex gave me works! I didn't thought to do that! I even didn't know that this symbol "-" was the problem!
That you again!!!

[bakerman2]

Please Login or Register  to view this content.

[maroon1]

Thank you for this version!! Just

Please Login or Register  to view this content.

and it works!
But it's less easy for me to understand it! why do you write "-1" here

Please Login or Register  to view this content.

[bakerman2]

Please Login or Register  to view this content.

has to be

Please Login or Register  to view this content.

sn is a matrix of 15 rows and 13 columns. sn(15,13)
result has to be matrix of 14 rows and 11 columns because you don't need Header row and the first 2 columns of your data. result(14,11)

[scottiex]

Maroon,
You would have seen all those #N/A that were appearing around your results and that was caused by your result size being wrong as pointed out by bakerman.

[maroon1]

Yes that right! Now I understand! thank you again!