Dear Sirs,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
<o></o>
I've found MrExcel.Com to be the best ever. I've benefited so much.<o></o>
<o></o>
However, I need to do Macro that automatically does printing papers by selecting number 1 and then 2 then 3 then 4 and on up to 80 on the same sheet. (You know I already set up the file as when choosing 1, it gives the info relating to number 1 and then writing 2 to give its related info. and then 3 and so on, that's already set up). The issue is now how to loop the printing automatically as when selecting 1 it prints its data and then selecting 2 it prints its data and on. The pause period between printing 1 & 2 should be 40 seconds to start next…etc<o></o>
<o></o>
I hope to find the structure <o></o>
<o></o>
Best regards,<o></o>
Maher<o></o>
<o> </o>
fficeffice" /><o></o><o
></o>I've found MrExcel.Com to be the best ever. I've benefited so much.<o
></o><o
></o>However, I need to do Macro that automatically does printing papers by selecting number 1 and then 2 then 3 then 4 and on up to 80 on the same sheet. (You know I already set up the file as when choosing 1, it gives the info relating to number 1 and then writing 2 to give its related info. and then 3 and so on, that's already set up). The issue is now how to loop the printing automatically as when selecting 1 it prints its data and then selecting 2 it prints its data and on. The pause period between printing 1 & 2 should be 40 seconds to start next…etc<o
></o><o
></o>I hope to find the structure <o
></o><o
></o>Best regards,<o
></o>Maher<o
></o><o
> </o>
