I am using Excel 97.

I come from an xBase background. In database programming, you can
write a function once, call it when you need it. Then if you need to
change it, you can it once, and all the other programs that use the
function will benefit. This avoids writing the same function over and
over again.

So how can I create a library for myself so that I can reuse code in
my macros.

There are several ways. The simplest probably is to use Personal.xls file.
More info he
http://www.personal-computer-tutor.com/personalxls.htm

RADO




"Rich" wrote in message
om...
I am using Excel 97.

I come from an xBase background. In database programming, you can
write a function once, call it when you need it. Then if you need to
change it, you can it once, and all the other programs that use the
function will benefit. This avoids writing the same function over and
over again.

So how can I create a library for myself so that I can reuse code in
my macros.