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