View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
webfort webfort is offline
external usenet poster
 
Posts: 1
Default Before print increment counter

Hi, I was wondering if any one could help me. I have designed a
standard sheet, nothing fancy. This may be very easy for most of you
and is my first time programming in Excel.


What I want to do is before a page prints I want a number to incremen
eg.

If i want to print this form 50 times the number will increment from
- 50 so I will then end up with 50 copies. I understand this could b
done the long way by me cutting and pasting the sheet 50 times an
inserting page breaks, but what I want to do is save it after, so whe
I come back to print some more it will start from 51.

If any one could help it would be much appreciated.

Thank you for you time.

Ashle

--
Message posted from http://www.ExcelForum.com