Hi All

i have a list of records in the range A10:K500 ... the value in column D
determines the values in columns J & K. Column D has 200 options. What i
want to do is use autofilter to filter the records on column D but then not
print columns J & K rather have the value from the first record in J
displayed in cell B3 and the value from the first record in K displayed in
B4, and then set my print range as A1:I500.

As we're dealing with filtered / visible cells here i can't figure out a way
to do it ... any ideas?

--
Cheers
JulieD