<<But the Range feature only recognizes the A1 format

Not true. Try

'--------------------------------------------------------------
ActiveSheet.Range(Cells(1, 1), Cells(5, 5)).Select
'--------------------------------------------------------------

You can replace the hardcoded numbers with variables

--
Message posted from http://www.ExcelForum.com