View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
momotaro
 
Posts: n/a
Default After printing, it will be given a new number

Hi all,

I just learned how to increment a number in my sheet each time by using the
macro. Now I have another question related to this. Is there a way that
after printing, it will be given me a new number instead of closing the
spreadsheet down and re-open? Please advise.

Thanks in advance.