EXCEL Printout

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

...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.

OK,
thanks, the Makro idea was it!!

Quote:

---

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: