So when your function finds a duplicate in the 2D array, what is it supposed to do? Delete the row? Delete the column? Delete the value? Does it work for you? Do you have an actual test script that can be run?

Share this post

Link to post

Share on other sites

laffo16 1

sorry, the function _arraydeldupes3d() looks for duplicate entries in a selected column from a 2-dimensional array, if it detects a dupilcate it will delete the entire row. yes it seems to be working for me, i was wondering if someone could double check the code for me, i think my ubound calls might be a little hairy. here is an example, including another small function which converts the result into combo box format. about the 3D, i was just unsure what to call it.