Date: prev next · Thread: first prev next last
2016 Archives by date, by thread · List index

I think you just introduced another set of questions.

Is the "&" used for macro substitution?  If so, how does that fit in?

I assume the lowercase n is a shorthand way of defining the variable type (n=number, s=string, etc.), and not part of the formula?

I went to Help with indirect(), not to much avail. I think I am not grasping your solution. Also, how do I assign the variable value, and, in terms of sequential execution, where do I put the assignment so it will be executed before the indirect() function?

Is it executed only once? Meaning, if I jump to a cell with my mouse (manual), is it possible that the indirect() function will fail because the assignment was not reread? (I am thinking in terms of procedural code here (Basic, Pascal, xBase).


On 07/20/2016 09:35 AM, Brian Barker wrote:
At 08:50 20/07/2016 -0700, John R. Sowden wrote:
If I have a cell with following formula, can I replace a cell coordinate, such as the 52 below, with a variable that I can assign at the top of my spreadsheet?


I trust this helps.

Brian Barker

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.