record a macro that uses the datafilteradvanced filter to another
locationprint from there.

--
Don Guillett
SalesAid Software

"Marco Simone" wrote in message
...
Hi,

I would like to set print area automatically with VBA code. Here is
problem:
Coloumn C in excel contains PAYMENT values sorted ascending. I would like
that when I click macro button, excel asks me numeric value and and marks
for printing (SET PRINT AREA) only rows where value in coloumn C is
greater
then value user entered in input box. It should be selected coloumn A to
coloumn C, where value is greater then choosed from input box.
Note that rows are sorted ascending by coloumn C.
Your help is greatly appreciated.

Thanks, Marco