Remote Excel VBA programming problem

[Euler]

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.

[Welshgasman]

I tend to use record macro to get the basics, then tailor to suit?
So filter for no spaces and add that code. Skipping the headers should just be the same?

[Euler]

I tried recording a macro but it didn't give me the results I need. I used Advanced Filtering to get the unique values and placed the results in another worksheet but I still got a blank in there.
It also seems that I need to include the header when I select the range. Otherwise, it won't pick up some values.

[Welshgasman]

So I would walk that column and delete the row if the cell is empty.
Then go to the top and delete the header.

[Euler]

That's an idea that'll work, I'm sure. Thank you for that.

Another one that I found on the internet was to create an array of unique values by walking through the unfiltered column. I haven't tried it yet but it sounds promising.

[Welshgasman]

Well if you already have code to get the unique values I would stick with that. Less to process?
Plus you should only have one empty cell if unique values?, so exit as soon as found and row is deleted.

[Gicu]

Lots of examples on this, can you show us your code? Here are some links:
https://www.listendata.com/2013/05/e...ue-values.html
https://stackoverflow.com/questions/...ray-from-excel

Cheers,