You may also want to do some research on Scope of variables and procedures. Standard modules are meant for user defined Functions, Subs and Variables that are to be project wide, to be called from other procedures.

----- wiseman wrote: ----

I have not done any programming, just recorded macros and copied bits o
code from web pages, so please excuse the dumb question, but I have don
searches in Excel help, google groups and not found the answer

I recently saw a useful looking piece of code, but it was supposed to be pu
the in your workbook module (not in a standar
module). Could someone explain in a fairly simply way what the differenc
is

Thanks
Barbar