I've been unable to set the print Range. I have a worksheet with 3 columns and 64 rows and I only want to print the first two columns.
I've tried using the Workshett.PrintArea in this way:
- Code: Select all
ws.PageSetup.PrintArea = "A1:B64"
But I wasn't successful. I've noticed that if I set the print range in Excel the property PrintRange is also updated. But Worksheet.PrintRange doesn't have a setter so I can't modify it.
What am I doing wrong?
Thanks in advance.