I have an Excel 2003 Worksheet which works perfectly well.
It includes calculations of the type:
I am working on converting the whole sheet to use dynamic ranges as data rows are being added all the time.
The above calculation no longer works, coming up with the #REF! error.
I can get the calculation working again if I omit the INDIRECT concatenation and put in the raw Range Name, that is to say:
PS Trivial, but I find the default font now used in code snippets in this revamped forum quite hard to read. Can I change that ?