TheWennerWoman
Active Member
- Joined
- Aug 1, 2019
- Messages
- 271
- Office Version
- 365
- Platform
- Windows
Hello,
I hope someone can help. I am looking to scroll through a list of items and add them to an array - but only if they are not in the array already. I also need to ignore empty cells.
So, for example, assume this is in column E:
Starting at the top, I would
add a
add b
ignore the next b because it's already been captured
add c
ignore the empty cell
add d
ignore the empty cell
add e
ignore the next e because it's already been captured
I would then have a message box telling me, in this case, 5 elements are in the array.
Is this possible?
Thank you in advance.
I hope someone can help. I am looking to scroll through a list of items and add them to an array - but only if they are not in the array already. I also need to ignore empty cells.
So, for example, assume this is in column E:
Code:
a
b
b
c
d
e
e
Starting at the top, I would
add a
add b
ignore the next b because it's already been captured
add c
ignore the empty cell
add d
ignore the empty cell
add e
ignore the next e because it's already been captured
I would then have a message box telling me, in this case, 5 elements are in the array.
Is this possible?
Thank you in advance.