On May 30, 9:08 am, "
wrote:
matches a first name string which should be able to be programmed into
the macro.

What do you mean? Like the example you provided?
Do While ActiveCell.Value < "John Smith"

Or only on the first name.