Avatar of Charles
Flag for United Kingdom of Great Britain and Northern Ireland

asked on 

Add specific ranges to macro summing named ranges from multiple tabs

This is a follow on from https://www.experts-exchange.com/questions/29135421/How-to-create-an-indirect-reference-to-multiple-named-ranges.html

The solutions to that question summed any/all numbers in the tabs.

What I need to do is sum only certain pre-defined areas.

Contra Martin's last posted proposals, I don't want to manually choose the ranges each time, I want the same ranges every time, baked into the code.

Can you replicate the solution to the above question, but applying the summing to ranges: B6:R8; B9:R14; X6:AR8 and X9:AR14.

Is it possible to make one named area for all those ranges together? Would this help?
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Martin Liss

8/22/2022 - Mon