Michael Harrison wrote:

Thank you for your reply and thank you very much for your patience and
help with this problem. I took the liberty of adding "End If" near the
end,

....I don't see where I missed one. Shrug.

and the routine works well. During my struggle to understand how
all of this works, I bought Walkenbach's books "Excel 2007 Bible" and
"Excel 2007 VBA for Dummies" (I am humble, some say for good reason). I
didn't find them to be as much help as I had hoped. What I really wanted
was a book which was like a dictionary of all of the allowable words in
VBA with their meaning, and also listed the typical phrases used. In
addition I would have liked it to have had a selection of example
programs which were analyzed word by word preferably explaining why that
syntax was chosen in preference to some other syntax which would also
have worked in that location. Do you know of any books like that, or are
there any sources on the web which use something like that format?

The help file comes to mind.

I suppose one of O'Reilly's nutshell books would be good, or their pocket
references, if they have one for VBA (or VB6 or older, but *not* VB.Net, or
any VB version that includes a year in the name, e.g. VB 2010). O'Reilly's
books are generally about the best there is, and their pocket references seem
to be decent enough, but I've only used one; YMMV. (The "for Dummies" series
isn't as helpful as some might think; the ones I've read seem to focus more
on specific tasks, rather than getting an overall understanding.)

Since I already knew VB when I started working in VBA, I had something of a
head start, and just had to learn the Office-specific things. (I also had
about 15 years of BASIC programming under my belt before I started on VB.) I
*did* buy a Microsoft Press book on programming Office VBA, and while this
was in the late 90's (for Office 97), it still would be of some use if I
could find the damn thing.

Anyway, thank you again for your help.

Np.

--
That is not prophecy; a good witch does not prophesy.
But it is my firm opinion.