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("C1:D5").PrintOut
'print range


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Varne" wrote in message ...
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