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.
|