Problem getting name of range with only one cell

Thanks Mallycat,
however, I'm working on an existing template and need a way out using ranges. Cannot replace all required ranges with tables.