Excel VBA Coding for Printing

  • Thread starter Thread starter Varne
  • Start date Start date
V

Varne

Hello

Could someone help on this?

I like to put an object on an Excel sheet. When I click it it should print a
selected range.

I tried a macro but I could go up to the pre view level only.

Thank You

M Varnendra
 
Hi Ron

selection.printout copies:=1, preview:=true, collate:=true

leaves with showing preview of the selection on the scree. So I have got to
push the print button to print.

What I like to have is the macro does the printing as well.

Regards
M Varnendra
 
Back
Top