| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Making cell reference absolute makes cell format text | Excel Worksheet Functions | |||
| Can INDIRECT function reference a cell that contains a formula | Excel Worksheet Functions | |||
| Array to named range conversion... | Excel Discussion (Misc queries) | |||
| How to dynamically reference a dynamic named range | Excel Worksheet Functions | |||
| Using the text from a cell as a range name in a formula | Excel Discussion (Misc queries) | |||
Linear Mode
