I am trying to get a difference of two arrays as a third array.
Here is a sample of what I am trying to do:
sample.png
So far I got this:
But I am getting a type mismatch error on this line:
Please Login or Register to view this content.
Any one know what can be wrong? Or even if I am correct with the code so far?Please Login or Register to view this content.
Last edited by Pimo; 11-24-2020 at 01:01 AM. Reason: solved
In your example, why does your Output show both mismatching records for toy4 but only one record for toy1?
Is your sample data in your picture the same as what you are running the code on?
When the error occurs, hover the cursor over arr1(i, j). What is the value?
you are getting the err for 2 reasons I believe. first of all, there are no elements in the array arr1(). second of all, according to this:
https://docs.microsoft.com/en-us/off...r-applications
you do not have the correct syntax of the method:
Please Login or Register to view this content.
--6StringJazzer so I added sample workbook, hope that it will be more clear
--Adam, Can you tell me arr1() is empty? I can't get it because code for the array seems to be fine
Also I have no idea what you mean with not correct syntax, Do you suggest that it should looks more like this?
Please Login or Register to view this content.
Last edited by Pimo; 11-23-2020 at 10:33 PM. Reason: to not post 2 posts
This is to amend your original code.
Different method,Please Login or Register to view this content.
Please Login or Register to view this content.
thanks a lot! both works perfect!
ありがとうございました！
You are welcome.
どういたしまして。
コロナには気を付けましょう。京都も大変なようですね。
気を付けましょう！第3波が来ているみたいですね。
京都も大変。。。
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks