Exactly what I need with modifications of course.

Thank you!
Jason

"Anne Troy" wrote in message
...
I do believe this is just what you ordered, Jason:
http://vbaexpress.com/kb/getarticle.php?kb_id=349
What luck! :)
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Jason B" wrote in message
...
I am trying to create a xls file with a counter that adds one to the
counter everytime it is opened. However, I do not want to save the file.

Does it have to be done in an external file? Can it be saved in some
variable?