<div>
Sounds like you need to use AutoFilter. Attach an example workbook to help better understand your requirements.
</div>


Sounds like you need to use AutoFilter. Attach an example workbook to help better understand your requirements.

Consultant

Jens Christian Wulff

<div>
Thanks Roy &amp;&nbsp;Ryan,<br />
<br />
Touch’e - this will work like a charm. I need to dive into the programming manual a lot more. Have a great weekend both. <br />
Best Regards<br />
Jens
</div>


Thanks Roy & Ryan,

Touch’e - this will work like a charm. I need to dive into the programming manual a lot more. Have a great weekend both.
Best Regards
Jens

<div>
So it is actually (sry for my lack of insight) possible to build and operate a multidimensional array with different autoformats build into each secondary array! That’s neat!
</div>


So it is actually (sry for my lack of insight) possible to build and operate a multidimensional array with different autoformats build into each secondary array! That’s neat!

<div>
<div class="content wysiwyg-content">
Need a VBA script to run upon opening of sheet giving the user a specifc selecton of rows based on content of one cell in every row. <br />
<br />
Thanks for all the expert advice!! BR
</div>
</div>


Need a VBA script to run upon opening of sheet giving the user a specifc selecton of rows based on content of one cell in every row. 

Thanks for all the expert advice!! BR

Display of row depending on values (yes / blank) in cell of row upon opening of sheet

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.