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
			End If

Open in new window

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.


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


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RWayneHAuthor Commented:
Not following this reply, perhaps you could suggest an edit?
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.
RWayneHAuthor Commented:
Thanks for the help.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
VB Script

From novice to tech pro — start learning today.