Is there any way to create a project-scope range variable? Doc says that project level variables are created when un-declared double, string or dataset variable is used (rather strange way of doing things). But this does not work with range variables, which is pity, since I have couple of ranges, which I use as functions. Workaround is to put them in ProjectEvents.ogs with @glob qualifier; but is there a straight way of doing this?
Can you just define the range variables under the AfterOpenDoc section in ProjectEvents.ogs? Then each time the project is loaded, the script under this section gets executed to create the range variables.
We are adding named range for next version (2022) and it will do exactly that, to define a named range with scope for project. Named range scope will be Sheet, Book, Project.
Project range variable
Posted - 06/25/2021 : 08:06:34 AM
