Excel VBA Coding for Printing

[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

 

[Ron de Bruin]

Hi Varne

Use one of the one liners here
http://www.rondebruin.nl/print.htm#Liners

Maybe one of the two

Selection.PrintOut
'print only the selection

Range("C15").PrintOut
'print range

 

[Varne]

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

 

[Ron de Bruin]

Use only

Selection.PrintOut

Or remove this form your code line

preview:=true

 

[Varne]

Yes Ron

It works.

Thanks.

M Varnendra

Use only

Selection.PrintOut

Or remove this form your code line

preview:=true