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.

2 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
770
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
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