Colleagues, I wrote a function in VBA to calculate the values of a two-dimensional array.
The principle of operation (I want to) is as follows: 1. The values entered were read and written in a single array; 2. Based on the elements of this array, the values of the two-dimensional array were calculated. In this case, the formula for the first column of the two-dimensional column and the rest column is different. 3. The output of the results on the tab.
Alas, the function does not work without any error detailing.
Please tell me where you can look to find the error.
Thanks for your support"
Can you write me an e-mail? To [email protected]. I have some suggestions how improve your code. I have found some mistakes there. I will wait for your message and I will explain to you.
Hi Kirill,
Look, did you make sure that the values were correctly entered and placed, like, say,
a1 a2 a3
b1 b2 b3, etc.?
On the other hand, remember that in programming matrices are usually treated like this instead:
a0 a1 a2
b0 b1 b2, etc.
That's to say, arrays begin with set element 0.
Check that.
- Badges
- Science topic
- Similar topics
- Analytical Chemistry
- Column