Filtering a Filtered Range

[beeblebrox82]

Hello all!

First post; I'm hoping to get some help on a programing issue I'm having. I'm pretty savvy in Excel, but I'm learning VBA trial and error style.


I'm making a sheet that will track and record defect data for my line operators. I have the user entering data into excel and then exporting that data into an access database using a macro. I can later import specific data back into the excel page to generate a report. All that is working fine, but I'm having a problem programing filters to further manipulate the data.

I first filter the imported range to pull out specific operators etc. From there I wanted to do a unique filter to display the individual operators; from there I can do a CountIF to find the number of times each operator shows up. I really want to get the unique filter to work so that I don't have to keep a database of operator names.

The code I have is simple:

Please Login or Register  to view this content.

If I do the unique filters manually, they work. If I do one manually and then run the macro, they both work. If I just run the macro, the 1st filter works, and then the the 2 unique filters only return the column heading. It's as if Excel isn't seeing that the data is there. I'm at a complete loss, and I can't seem to find any help online. Anyone have an idea?

Thanks a ton!
Nate

[rylo]

Nate

Firstly, can you please review the forum rules regarding wrapping code. I've edited your post for you this time. Makes things much easier to read.

When you manually do the filter, you would be removing the criteria range. The only way I could replicate this in code was to explicitly remove it from the first unique action. See if this works for you.

Please Login or Register  to view this content.

rylo

[beeblebrox82]

I replaced mine with yours and it works like a champ. I'm annoyed that omitting that would cause problems, it doesn't show up when you record the macro' when I looked up the method in the help I figured it wasn't needed as there was no criteria. Thanks a ton, I've been banging my head against the table all day. Sorry about the wrapping code. I'll figure ou how to put it in the box for next time.

[rylo]

Hi

At the top of the programming forum is a link to the forum rules. Follow the prompts and item 3 covers code wrapping. It also shows how this can be done.

Easiest way is to highlight your code, then press the # icon.

rylo