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

John



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?
=sum(a1:a52)

Yes:
=SUM(INDIRECT("A1:A"&Xn))

I trust this helps.

Brian Barker





--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Reply via email to