Good morning,
i have an error occuring in my code, but im too bad to understand how this issue might be to solve, I've excluded everything not relating to the problem:
Please Login or Register to view this content.
Good morning,
i have an error occuring in my code, but im too bad to understand how this issue might be to solve, I've excluded everything not relating to the problem:
Please Login or Register to view this content.
Last edited by Fyv03; 02-09-2021 at 04:01 AM.
If I substitute the comparison by "vArrGesamt(i, 2) = vArrAT(j, 1)" it works
But im thinking its the same thing, what might that be?
It hard to test you code, or even create a file to test.
But the issue is you are assigning an array to an element of the vArrQm array.
prior to using the array you define it as beingPlease Login or Register to view this content.
perhaps you meant to include a row/column index as you did for the other arrayPlease Login or Register to view this content.
Please Login or Register to view this content.
vArrQm = Workbooks("ALL.xlsx").Worksheets("DUM").Cells(1, 7).Resize(iZeile2, 4)
vArrQm array is having only 4 columns.
vArrQm(i, 5) = vArrArtikel(i, 1)
vArrQm(i, 6) = vArrAT
Here you are referring to the 5th and 6th columns of the array vArrQm
So Error will be
"Subscript out of range"
Last edited by kvsrinivasamurthy; 02-09-2021 at 05:06 AM.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Not quite correct, but you got the problem right.
I forgot to put "vArrQm(i, 6) = vArrAT(i, 1)" instead of "vArrQm(i, 6) = vArrAT"
Thank you, i guess im just tired^^
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks