The quick and dirty way to fix it, is to delete the Macro (Alt + F8, then highlight macro, then hit delete button), then create a new Macro. The advantage is then you don’t have to edit the code in the VBA editor.

Dear stacybsimmons,

EXCELlent!!!!!

–excelisfun

Dear stacybsimmons,

Any time you get a zero or blank answer from Advanced Filter, it means that no records match. So eitherno records match or the criteria is not correct.

–excelisfun

Dear PrincessWithSkills,

I am glad that it is useful for you!

–excelisfun

Dear mond118,

Yes, instead of just the B column, use the B – D columnns for the “List range” in the Advamced Filter dialog box.

–excelisfun

Dear mutony9,

Excel 2007 rules over any other version for many reasons. On reason in the Filtering feature that has automatic today, tomoorw and yesterday. If you wanted to do it with a formula like in this video and you had date column, you could use the formula =Today+A1, then put -1 in A1 for yesterady, 0 for today and 1 for tomorrow. You could create a column with Date from your separate column if you used the DATE function.

–excelisfun