VBA code for set print area

  • Thread starter Thread starter Marco Simone
  • Start date Start date
M

Marco Simone

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
 
record a macro that uses the data>filter>advanced filter to another
location>print from there.
 
Back
Top