auto select print area and prints Closed

Question

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.

rizvisa1 · Answer

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

man.jangra · Answer

thanks for your response.
let me try

Auto select print area and prints

2 responses

Similar discussions

Subscribe To Our Newsletter!