Hello LEAP team!
I am trying to automate the Energy Balance method to Excel, as we need this for a project.
I kept getting results, but always the wrong number. I have figured out my code kept referring to a specific region, not "All Regions". I am interested in the total number though.
I have tried specifying "All Regions" in different ways, but I get errors instead. How do You define "All Regions"? I have tried "ActiveRegion = "All Regions"", which makes the macro run forever. I have tried using "All Regions" and "
" in .ValueR, but that fails.
Do I have to run it for each specific region? That seems like a waste.
Gregers