Thanks, Charles, you've given me a lot to study
. I can tell I need to start at the beginning with VBA. I'm a very good (read "serviceable") BASIC programmer, and I used to compile a lot of BASIC programs with quickbasic; even dabbled in machine code for early Commodore machines. I get the general process of coding but the intricacies of ?Visual Basic (or whatever VBA might be) seem beyond me at present. One of the things I read on-line recommended constructing a macro with "record" (I've done maybe a hundred of these) and then dissect it by going into "edit" mode. Do you think this is a reasonable strategy? I just want to become more facile with macro writing, not looking to write groundbreaking software.
Anyway, thanks for responding.