Had to go to work on Sunday to test it out. Couldn't wait till tommorrow.
daleyman, your solution worked, but as some rows got deleted and pagecount changes it still prints 7 pages. I got for example page 7 of 4. So it didn't suite me completly. Thanks anyway.
Jay Petrulis macro was just what I needed. It worked perfectly. Thanks.
Can you please explain what the following means and do?
Dim Pagecount as Integer
Dim PageNumber as Integer
PageCount=ExecuteExcel4Macro("Get.Document(50)")
And I bother you a little more.
Can you please add a code that let me choose how many copies I want to print.
Thanks in advance.
Lighting
daleyman, your solution worked, but as some rows got deleted and pagecount changes it still prints 7 pages. I got for example page 7 of 4. So it didn't suite me completly. Thanks anyway.
Jay Petrulis macro was just what I needed. It worked perfectly. Thanks.
Can you please explain what the following means and do?
Dim Pagecount as Integer
Dim PageNumber as Integer
PageCount=ExecuteExcel4Macro("Get.Document(50)")
And I bother you a little more.
Can you please add a code that let me choose how many copies I want to print.
Thanks in advance.
Lighting