IT Director

Dan Carp

<div>
Thanks Rgonzo1971 - appreciate the clarity of your script. &nbsp;Will hold onto these steps for future needs. &nbsp;Cheers!
</div>


Thanks Rgonzo1971 - appreciate the clarity of your script.  Will hold onto these steps for future needs.  Cheers!

<div>
<div class="content wysiwyg-content">
I've got a line in a VB script that currently reads:<br />
<br />

<pre><code id="code-10-29092361-1">ActiveSheet.Range(&quot;$A$1:$DD$500&quot;).AutoFilter Field:=6, Criteria1:=Array( _ &quot;0a&quot;, &quot;1b&quot;, &quot;s&quot;, &quot;t&quot;, &quot;ss&quot;), Operator:=xlFilterValues</code></pre>
<br />
I need to add to this line to have it include in the array the existing items plus anything in Field 6 that begins with a &quot;z&quot;. &nbsp;I understand that to determine whether a string starts with &quot;z&quot; I can do this:<br />
<br />

<pre><code id="code-10-29092361-2">Result = String1 Like &quot;z*&quot;</code></pre>
<br />
But could somebody explain to me how I could incorporate that result into the array? &nbsp;Thanks!
</div>
</div>


I've got a line in a VB script that currently reads:

(CODE)

I need to add to this line to have it include in the array the existing items plus anything in Field 6 that begins with a "z".  I understand that to determine whether a string starts with "z" I can do this:

(CODE)

But could somebody explain to me how I could incorporate that result into the array?  Thanks!

Include &quot;Starts with&quot; in VB Array

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

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.

Include &quot;Starts with&quot; in VB Array

Include "Starts with" in VB Array