不好意思, 又贴了一次. 求 助Excel Macro 高手

I have a pretty repeative printing which I need to run everyday many times:

- imaging working with a worksheet containing product and company information, and how many boxes for shipping. I need to enter a number in a cell (saying B6), then print this worksheet; then I need to increase 1 to the number I just entered (say starting from entering 1, then enter 2, then 3, then 4.....), or decrease 1 from the number (saying starting from entering 10,then enter 9, then 8, then 7 .....), The worksheet is printed every time when a number is entered.

then,
- when the last number entered equal to a value (saying 10 for starting from 1), I need to clear contents from three seperated cells (saying the cell B5, the cell A7 and the cell B9), then print the worksheet.

how to creat a Excel Macro to accomplish this task?

waiting for your input. Thanks.

所有跟帖： 

• question hard to understand -user1- ♀ (71 bytes) () 01/27/2005 postreply 21:35:31

• 代码在里面 -小张- ♀ (615 bytes) () 01/27/2005 postreply 23:04:23

• 谢谢了. -虽没来得及run,但- ♀ (29 bytes) () 01/29/2005 postreply 10:24:26

• copy, past, and modify macro -vbdotnet- ♂ (737 bytes) () 01/28/2005 postreply 19:42:14

• 多谢, 多谢 -Manythank- ♀ (46 bytes) () 01/29/2005 postreply 10:28:05