VBA to filter multiple sheets

**Zimbo** · 09-23-2008, 11:19 PM

Hi All,

I have a macro that filters all the sheets in a workbook based on a cell entry on sheet 1. The filter runs through Columns 1.

This works quite well(other than flicker issues).

The problem is I also need the filter to run through column K and show rows that have an empty cell.(i.e UnInvoiced) I have tried the below code, but it shows the empty formula rows below all data not the uninvoiced rows.

Please Login or Register  to view this content.

Please Help

Cheers

Adam

**MatrixMan** · 09-24-2008, 04:17 AM

Hi Zimbo .. others may have a different view, but for me, it's difficult to help without seeing the full code and trying to work out what's happening with 3 lines of code, those being only part of a conditional statement ... well, it could be anything really and may not even be in these lines. If you'd like to post it or prefaerably attach your workbook, I'll take a look for you. Are you applying these filters on A and then K? Depending on your data, they may be incompatible ..

On the flicker issues when filtering sheets - have you used:

Please Login or Register  to view this content.

Just don't forget to turn it back on again ..

Cheers, MM.

**Zimbo** · 09-25-2008, 09:06 AM

Hi All,

Accidently posting newer post is correct.

**Zimbo** · 09-25-2008, 09:38 AM

Hi MM,

I have managed to fix the flicker issues ( I was calling macros in the wrong places). Please find my code for the sheet sort below.
I am either sorting by Column A or Column K, but should not sort Column K unless Column A has a value. I have tried the sort criteria as both ="" and ="=".

Please Login or Register  to view this content.

The section "Uninvoiced" is the one I am having issues with.

All help is appreciated.

Cheers

Adam

**MatrixMan** · 09-25-2008, 12:56 PM

If I understand correctly that you're trying to filter first on col A for non-blanks and then any blanks in col K, try this:

Please Login or Register  to view this content.

I'm not sure why you've got specialcells etc in there; if the autofilter is on the range for the filter is implied and you don't need to specify it.

Hope that helps. MM.