Thanks a lot. This helped actually and I have for sure a better understanding.
Sorry if I haven't been able to explain my doubt before.

I ll get straight to the last question:
Supposing I have a cell that refers to an array, let's say cell F3 = A1:G1. The retrieved value, displayed by the cell, will be:
- A3 if I entered without ctrl-shift
- A1 if I entered with ctrl-shift

Regardless of what that value is on the spreadsheet...
If I target that cell with a VBA function, or with an external plug-in, whatsoever, what I will have as information?
- the value of F3 in the spreadsheet?
- the string "=A1:G1"?

Hope this clarify my doubts
Thanks