HOW TO EXTRACT CELL REFERENCE AS TEXT FROM NAMED RANGE
 

Is it possible to extract cell reference as text from a pre-defined NAMED
range?
For the following PURPOSE....
E.G.

defined NAME : RANGER
cell reference : square matrix type 45X45: e.g. A1:AS45

I need to autolocate the nextcells to bottom and rightmost cells
i.e. ..i need to include cells A46 to AS46 and AS1 to AS45 in a built in
tabulated formula and click solver named scenario.

please help....i dont know anything about VBE...i prefer to use ordinary
type of standard excel functions....
thanks....


--
"Bright minds are blessed to those who share them.."-rsb.