Hi all,

I have seven column(A:G) data starting from row2 as
label and from row 3 onwards data, which would be
filtered on column 7. I want to apply a second filter
from this filtered data on column 2 and then set print
area as the filtered range less one column (A:F)

how can I do this with code?

TIA

Soniya