Excel Single Row Checking

[philipq]

Did that and it works, Thanks.

Could you please explain the below code

Macro Amended Orders AL - VISTA Verification

Code:

Copy      Help

,y.GetRangeInfo("<sel>" 0 row1)

Does the above variable have the entire used row stored in it?
Can we go to the next cell beyond the last used one?
If so, what is the code to offset to it.
Basically, I need to enter unfound text in the last unused cell of the same row and highlight it in red.

Thanks,