Hi ,
Thanks for your patience and so sorry for the long-time waiting.
You can use the following code to set the print area:
- Code: Select all
workbook.Worksheets[0].PageSetup.PrintArea = "A1:F8";
//give the area you want to print
If you have any other questions, please feel free to contact us.
Have a nice day.
Kind Regards
Suvi
e-iceblue support