I discovered the following statement
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select

now I want to set a var to the selected range.

Can anyone help; this VB stuff is all new to me and I really appreciate the
help I have received from many of the Guru's on this site!!!

Thanks again for your time and knowledge.

El Bee