In my macro, I have defined FOR loop for first 100 rows as below
For i = 1 To 100
If Sheet2.Cells(i, 3).Value = "" Then
Cancel = True
MsgBox ("message data")
Exit For
End If
I am using cell(i,3), cell(i,4) and so on to validate the value in each cell. Now if there is an error in any my validation, I need to place the cursor. The challenge is I am using cell(i,3) and I don’t know how to use it in Range(“ “).Select
Please help
Bookmarks