EXCEL Printout

[LongJohnDa]

Hi,
I'm normally in C++ at home, but a friend asked me to do him a favour and now I#m sitting here. He had a Work with some sheets. He will have some Controlls and a Submit button. Thats easy I got it. But now the problem:

If he press the submit button he will have a scan over the controls OK I got with TRUE or FALSE and if TRUE there should be a printout of a grafik ora defined printaerea.
The Object excel.worksheet.printout(..,..,..,) gives me no chance to define the aerea what is to print
Please help me anyone
thanks
Long John

[Matt_T_hat]

...Let me just check... you want to set the print area?

If I am correct try this little trick: record macro, set print area, stop macro view VBa code this can now be edited into your code just before the printing section in what ever way you disire.

[LongJohnDa]

OK,
thanks, the Makro idea was it!!

[LongJohnDa]

Originally posted by Matt_T_hat
...Let me just check... you want to set the print area?

If I am correct try this little trick: record macro, set print area, stop macro view VBa code this can now be edited into your code just before the printing section in what ever way you disire. :wave: