I'd even put it on another worksheet--then inserting/deleting rows would be
safer.

But if you don't have enough control over that workbook, you can still have your
macro use a completely different workbook, too.

David wrote:

Dave Peterson wrote

Is there anything on that row that indicates that the name in column
AC should be used?

Nope

If only you (as a human) know what's in that list, maybe you could use
another workbook to create the list and cycle though that. It might
be easier than fiddling with a range name that changes.

I think I'd rather opt to copy my caseload names from AC to another column,
Hide it, Name and cycle through that range. I could add/remove names
to/from that list manually

--
David

--

Dave Peterson