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?

			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)

Open in new window

RWayneHAsked:
Who is Participating?
 
Rgonzo1971Commented:
HI,

you test val_PurOrdNum but on the do while but I do not see it could change afterwards

Regards
0
 
RWayneHAuthor Commented:
Not following this reply, perhaps you could suggest an edit?
0
 
RWayneHAuthor Commented:
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.
0
 
RWayneHAuthor Commented:
Thanks for the help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.