Page 1 of 1

Printing a range of selected cells with macro

PostPosted: Fri Jun 28, 2019 3:00 am
by mijo
hi
i want to print a range of selected cells using marco. i used record macro but when the recorded macro runs, it displays print dialog and i have to click "ok" button to continue printing. what i need is printing a range of selected cells only, directly without print dialog appears. can anyone help me with a simple macro example or a link which i can learn.
i am very very new in programming.
thanks for all helps

regards

Re: printing a range of selected cells with macro

PostPosted: Fri Jun 28, 2019 3:08 am
by robleyd
A search of the forum returns a number of topics that may be helpful to you.

Re: printing a range of selected cells with macro

PostPosted: Fri Jun 28, 2019 6:18 am
by Zizi64
i used record macro


You must wrirte your macros, but not record them. The recorder has a limited capability: In most of cases you need use the API functions (and sometimes the Dispatcher too) in your macros.
API: Application Programming Interface