I'm trying to remotely control an Excel workbook with MS Access VBA. I have a filtered column and I'd like to copy just the unique filtered items and paste them to another location to make an array. I don't want the header or any blanks in the array.
So far, I've gotten the unique values in a new worksheet but they include the header and a blank.
Can anyone help with this issue? Thanks for the help.