I am trying to set an area of a filter as a print area, and the way I am
trying to do this is as follows:

Filter my results
Select the results
Give the selection a name
Set the named range as the print area

I tried recording a macro to do this, but when I set the print area, it
gives it specific cells (eg A1:D23). The problem with this is that the area
will be different everytime, so can someone please tell me how to do this?

cdb