Getting activesheet.range to refer to a name that varies...

Thank you both so much for all your help... I HATE working with VBA, and realized that I had messed up the whole example document after I posted it (did it hastily).

Unfortunately I am obviously in way over my head and have no idea even where to put the mentioned codes, but thank you very much anyway.