Excel Single Row Checking

[philipq]

Thanks Got it.

How do I refer to the first column in the same row in below code:

Macro Amended Orders AL - VISTA Verification

Code:

Copy      Help

,y.Format(ExcelRange(1 r2.Row) f)