Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 69
Default Generating a numbered document

Hi
I have a macro which uses code to populate certain cells in a document and
then prints this page.
I would like to be able to use code to generate a sequential whole number
each time the macro is run and place this number in a cell on the document to
be printed. Thus whenever the document is printed it is numbered and this
number increases by one each time.

How can this be done please?

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 258
Default Generating a numbered document

Hi Alan,

yes, it can be done.

With that I know from your post, I am not able to write any code
example. So I have to repeat my advice: explore workbook_before print
event in VBA help.

Regards,
Ivan

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
create numbered sortable numbered list in excel coloradio Excel Discussion (Misc queries) 2 November 15th 06 06:50 PM
Generating a numbered document Alan M Excel Programming 1 April 20th 06 09:42 AM
Numbered Lists - Take 2 [email protected] Excel Discussion (Misc queries) 11 April 5th 06 05:09 AM
how do i create an automaticly generating number for a document? Brad Excel Discussion (Misc queries) 2 June 15th 05 01:03 PM
numbered labels dave Excel Programming 2 February 22nd 04 08:01 PM


All times are GMT +1. The time now is 12:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"