Just wondering what the best process of this would be.
Originally I was trying to write the array out into another sheet then do matching, but that was a very very slow and seemed like a redunant process if the values are already stored in an array.
What I am trying to do is I have column A with a bunch of numbers in it.
548543
45435
459873453
43598743
Then I have an array with info in it.
The array is myobj
For Each user In myobj
I am trying to compare.
user.Name to column A.
Then write user.FullName is column B in that same row.
What would be the best method of doing this?
Thanks!
Originally I was trying to write the array out into another sheet then do matching, but that was a very very slow and seemed like a redunant process if the values are already stored in an array.
What I am trying to do is I have column A with a bunch of numbers in it.
548543
45435
459873453
43598743
Then I have an array with info in it.
The array is myobj
For Each user In myobj
I am trying to compare.
user.Name to column A.
Then write user.FullName is column B in that same row.
What would be the best method of doing this?
Thanks!