<div>
Hi, Rayne.<br />
<br />
Please let us know the address range of the 18 components - assuming that the actual formulas are in D8 to D30 and the results are in F8 to F30<br />
<br />
Thanks,<br />
Brian.
</div>


Hi, Rayne.

Please let us know the address range of the 18 components - assuming that the actual formulas are in D8 to D30 and the results are in F8 to F30

Thanks,
Brian.

readAndDisplyFormulas-V3.xlsm

<div>
Hello Brian,<br />
<br />
Simply speaking –You Rock. &nbsp;ALL Hats off to you!!<br />
Thanks for the effort you put in here.<br />
<br />
Thank you :)
</div>


Hello Brian,

Simply speaking –You Rock.  ALL Hats off to you!!
Thanks for the effort you put in here.

Thank you :)

<div>
Thanks, Rayne. Glad you're sorted!
</div>


<div>
<div class="content wysiwyg-content">
This is follow up to this previous question<br />
<a href="https://www.experts-exchange.com/questions/27977620/Read-and-Display-formula-Components.html?anchorAnswerId=38724213#a38724213" rel="ugc">https://www.experts-exchange.com/questions/27977620/Read-and-Display-formula-Components.html?anchorAnswerId=38724213#a38724213</a><br />
<br />
How can the formula components be listed in a dynamic way, assuming there are 18 components?<br />
<br />
Thanks
</div>
</div>


This is follow up to this previous question
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_27977620.html#a38724213

How can the formula components be listed in a dynamic way, assuming there are 18 components?

Thanks

Formula View-Follow Up

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.