<div>
Do you want those ranges to add to the same ranges on sheet A? In other words B6:R8 on sheets B, C and D to B6:R8 on sheet A, etc?
</div>


Do you want those ranges to add to the same ranges on sheet A? In other words B6:R8 on sheets B, C and D to B6:R8 on sheet A, etc?

29135628.xlsm

Charles

<div>
<div class="content wysiwyg-content">
This is a follow on from <a href="https://www.experts-exchange.com/questions/29135421/How-to-create-an-indirect-reference-to-multiple-named-ranges.html" rel="ugc nofollow">https://www.experts-exchange.com/questions/29135421/How-to-create-an-indirect-reference-to-multiple-named-ranges.html</a><br />
<br />
The solutions to that question summed any/all numbers in the tabs.<br />
<br />
What I need to do is sum only certain pre-defined areas. <br />
<br />
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. <br />
<br />
Can you replicate the solution to the above question, but applying the summing to ranges: B6:R8; B9:R14; X6:AR8 and X9:AR14. <br />
<br />
Is it possible to make one named area for all those ranges together? Would this help?
</div>
</div>


This is a follow on from https://www.experts-exchange.com/questions/29135421

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?

Add specific ranges to macro summing named ranges from multiple tabs

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.