I defined a Name, called ARNG, that stores a range of cells.
I used the INDIRECT function to define the range and I passed as argument a concatenation of strings.
I would control the value of the Name ARNG.
In practice:

iniz = 5
nf = MID(INFO.DOC(1);FIND("]";INFO.DOC(1))+1;LEN(info.doc(1)))
ARNG =INDIRECT(nf1&"!$D$"&iniz&":$D$"&(iniz+45))

How can I control what value the Name ARNG assumes?
Thanks in advance.
Alex.

I think I'm just looking for an inverse function of INDIRECT.

Have you ever heard about this one?

Alex.

Hi Alex,

As I know, I have never heard one similar function. From my view, If you want to implement one, you will need to define the value containing the
reference information. For example, the cell $B$2 has the value "1000(A1)", then you can know A1 contains the address B2 so we can use =interact
($A$1) to retrieve the value "1000(A1)". However, this way, the value referenced will have to contain more info for the reverse checking of Indirect
function.

Please feel free to let me know if you have any further questions.

Best Regards,
Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

Thank you Wei-Dong,

I looked for a function INTERACT but I didn't find any function called this way.

Could you be more precise, please?

Thanks, Alex.

Wei-Dong XU [MSFT] wrote:
Hi Alex,

As I know, I have never heard one similar function. From my view, If you want to implement one, you will need to define the value containing the
reference information. For example, the cell $B$2 has the value "1000(A1)", then you can know A1 contains the address B2 so we can use =interact
($A$1) to retrieve the value "1000(A1)". However, this way, the value referenced will have to contain more info for the reverse checking of Indirect
function.

Hi Alex,

Thus far, I don't know there is one such function existing either. My suggestion is below:
1) the value in $A$1 is: "B2" so that indirect can point to $B$2
2) we put the value 1000 in $B$2, so that we can retrieve the value by "=indirect($A$1)"
3) now we want to obtain the $A$1 from the value in $B$2. Since there is no any existing function available, we have to put some info in the $B$2
for the reverse locating. I'd suggest we can put (A1) after the value 1000. This way, we will know the value in B2 is 1000 and this cell is referenced
by A1.

Please feel free to let me know if you have any question.

Best Regards,
Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

Hi Wei-Dong I resolved this way.

If, as told at the beginning of this thread, we have

iniz = 5
nf = MID(INFO.DOC(1);FIND("]";INFO.DOC(1))+1;LEN(info.doc(1)))
ARNG =INDIRECT(nf1&"!$D$"&iniz&":$D$"&(iniz+45))

Putting in a cell the following code

=INDEX(ADDRESS(ROW(ARNG);COLUMN(ARNG))&":"&
ADDRESS(ROW(ARNG)+ROWS(ARNG)-1;COLUMN(ARNG)
+COLUMNS(ARNG)-1);1)

it will return

$D$5:$D$50

i.e. what I want

Thanks, Alex.

Wei-Dong XU [MSFT] wrote:
Hi Alex,

Thus far, I don't know there is one such function existing either. My suggestion is below:
1) the value in $A$1 is: "B2" so that indirect can point to $B$2
2) we put the value 1000 in $B$2, so that we can retrieve the value by "=indirect($A$1)"
3) now we want to obtain the $A$1 from the value in $B$2. Since there is no any existing function available, we have to put some info in the $B$2
for the reverse locating. I'd suggest we can put (A1) after the value 1000. This way, we will know the value in B2 is 1000 and this cell is referenced
by A1.

Please feel free to let me know if you have any question.

Best Regards,
Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.