Hi Lee

You can use a other workbook to store the criteria
My new Filter Add-in is doing that also
http://www.rondebruin.nl/easyfilter.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl


"FinChase" wrote in message ...
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