Let's say you have an array created as follows:
Let's then say you have another named range called RangeTest.Please Login or Register to view this content.
Assume RangeMaster has the values 1,2,3,4,5,6,7,8,9, and 10 in it and RangeTest has the values 1,3,5,7 and 9 in it.
I want to have some kind of code that loops through the value in RangeTest and if that value exists in the array rngMaster then remove that value.
So the goal would be for rngMaster to end up with 2, 4, 6, 8 and 10 as elements in that order.
Arrays are new to me.
Can you do something like:
If so, can someone help with the code in the middle to actually remove the array element?Please Login or Register to view this content.
Bookmarks