HOW TO EXTRACT CELL REFERENCE AS TEXT FROM NAMED RANGE

G

Guest

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

Peter T

RANGER = A1:AS45

A46:AS46
OFFSET(RANGER,ROWS(RANGER),,1)

AS1:AS45
OFFSET(RANGER,,COLUMNS(RANGER),,1)

Regards,
Peter T
 
G

Guest

thanks for reply,
i paste the formulas in the range and what i got are the sum of values in
every rows and sum of values in every columns
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selecting a named range, the name of the named range is in a cell 6
Populating a Named Range & Cell Array 0
Combox Box - Need to Reference Named Range 2
Cell reference in User Defined Function. 19
setting one worksheet cell range reference to another worksheet 1
Referring to a named range 2
show cell reference as text 5
How to get named range value? 5

Top