As far as I know, the only way to create ranges based on
variables is by using the Cells collection.

For example:

myWS.Cells(myRow, myCol).Select

myWS - Worksheet Object
myRow - an Int or Long ( 32768 limitation on some systems)
myCol - Int




-----Original Message-----
Is there a way to specify a range based on a varible, for
example


Range("Asomenumber").Select

eg. where somenumber = 5, so that A5 in this case is
selcted, but if
somenumber changed then another cell selected.