RWayneH
asked on
Not Identifying a blank cell value?
Why would the following not see a blank cell so I make the first blank row = I5 and SetCurrentRow to that?
Any ideas?
Any ideas?
If i4 > 1 Then 'if SO row is >1 chg i5 SetCurrent row to the first blank.
val_PurOrdNum = DataTable.Value("PurOrdNum","POItemInformation")
Do While Not val_PurOrdNum = ""
i5 = i5 + 1
Datatable.GetSheet("POItemInformation").SetCurrentRow(i5)
Loop
End If
Datatable.GetSheet("POItemInformation").SetCurrentRow(i5)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
ASKER
Thanks for the help.
ASKER