.. But my question is how to name such a range
without actually selecting the cells with the mouse.

Probably need vba. Hang around awhile for those versed in vba to plough in
here. Or try a post in .programming.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---