| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel VBA Coding for Printing
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel VBA Coding for Printing
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel VBA Coding for Printing
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" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel VBA Coding for Printing
Use only
Selection.PrintOut Or remove this form your code line preview:=true -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Varne" wrote in message ... 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" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel VBA Coding for Printing
Yes Ron
It works. Thanks. M Varnendra "Ron de Bruin" wrote: Use only Selection.PrintOut Or remove this form your code line preview:=true -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Varne" wrote in message ... 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" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA/Excel help - Coding ComboBoses...... | Excel Discussion (Misc queries) | |||
| Need Help with Coding a ComboBox in Excel/VBa...... | New Users to Excel | |||
| Can Excel do this with coding? | Excel Worksheet Functions | |||
| help with coding in excel | Excel Worksheet Functions | |||
| Simple coding in Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
