VBA code for set print area
 

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

VBA code for set print area
 

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