Its covered pretty well in the help for excel vba. Did you take a look?

Regards,
Tom Ogilvy

Vixyswillie wrote in message
...
Thanks, Jim. Can you provide some specifics in terms of how I would go
about that? I'm a newbie to VB. Any help you could provide would be
much appreciated. Thanks!


On Tue, 15 Jul 2003 08:57:39 -0400, "Jim Rech"
wrote:

I'd suggest using SaveSetting and GetSetting to record and retrieve the
last
used number in the registry.