<div>
Not following this reply, perhaps you could suggest an edit?
</div>


Not following this reply, perhaps you could suggest an edit?

<div>
I see it now, I was not checking the new value, when it moved down a row. &nbsp;I just copied Ln2 inside the Do While after Ln5. &nbsp;I did not even see that. &nbsp;Thanks.
</div>


I see it now, I was not checking the new value, when it moved down a row.  I just copied Ln2 inside the Do While after Ln5.  I did not even see that.  Thanks.

<div>
<div class="content wysiwyg-content">
Why would the following not see a blank cell so I make the first blank row = &nbsp;I5 &nbsp;and SetCurrentRow to that?<br />
Any ideas?<br />
<br />

<pre><code id="code-10-28640874-1">			If i4 &gt; 1 Then 'if SO row is &gt;1 chg i5 SetCurrent row to the first blank.
				val_PurOrdNum = DataTable.Value(&quot;PurOrdNum&quot;,&quot;POItemInformation&quot;)
				Do While Not val_PurOrdNum = &quot;&quot;
					i5 = i5 + 1
					Datatable.GetSheet(&quot;POItemInformation&quot;).SetCurrentRow(i5)
				Loop
			End If
			Datatable.GetSheet(&quot;POItemInformation&quot;).SetCurrentRow(i5)</code></pre>
</div>
</div>


Why would the following not see a blank cell so I make the first blank row =  I5  and SetCurrentRow to that?
Any ideas?

(CODE)

Not Identifying a blank cell value?

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.