Previous Topic Next Topic

Auto select print area and prints

Closed
man.jangra Posts 2 Registration date Sunday June 15, 2014 Status Member Last seen June 15, 2014 - Jun 15, 2014 at 09:46 AM
man.jangra Posts 2 Registration date Sunday June 15, 2014 Status Member Last seen June 15, 2014 - Jun 15, 2014 at 10:52 AM
can anybody explain the Macro for auto select print area and print with a Print button in any cell

i've a sheet with receipt. and i want to print random receipt. is there any way that i click on a print button and the mentioned receipt auto selects the print area and print.
Help me please.
Related:

2 responses

Answer 1 / 2
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 15, 2014 at 10:31 AM
You can record a marco to do that. If you start marco recorder, do the set print area and print, and then stop the macro, this will give u a template to work from. You can then edit to to make it more generic to suit your need
1
Answer 2 / 2
man.jangra Posts 2 Registration date Sunday June 15, 2014 Status Member Last seen June 15, 2014
Jun 15, 2014 at 10:52 AM
thanks for your response.
let me try
0

Similar discussions

Any auto clicker for Xbox One?
vic11con -
julietdcosta -

13 responses