: Thanks for your interest. This is my first go at VBA so
: still getting to know the ropes. The brain is 63 years
: old
:
: Below is my first go at this exercise. Still not sure on
: the loop actions however.
:
: If you can give me some hints as to the correct action and I
: will try!! and get it together.

If you are building a car engine from scratch, you wouldn't
just throw the parts into a box and expect the engine to run.
You have to learn which parts fit together, test those newly
formed sections and then learn how those sections connect and
test those new connections until you end  up with a working
engine.

Writing computer programs is no different. You can't just
throw words in a file and expect a finished program to pop out.
You have to start with a simple project and work your way up.
When learning a new language, one of the most common tasks is
the "Hello World" program. Start with this tutorial.

http://www.anthony-vba.kefra.com/vba/vbabasic1.htm

It will show you some basics. (I picked it out from a
Google search.) Learn some basics and then bite off a bigger
project like this one.