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 i
somenumber changed then another cell selected

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