Is it possible to write the criteria for advanced filtering in VBA code
rather than put it in a range? It doesn't appear that you can type a single
number in as criteria. I'm going to be filtering different large
spreadsheets each week for the same criteria and I don't want to add any more
rows to the workbook.

Thanks, Lee