sorry worksheets not worksheet. i tested it and it is working. let me know!
![]()
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim tmpbox As Range application.screenupdating = false Set tmpbox = worksheets("TargetSheet").Range("A8") worksheets("TargetSheet").Unprotect Do Until tmpbox.Row = 26 If tmpbox.Value = "" Then tmpbox.Offset(0, 2).Value = "" End If Set tmpbox = tmpbox.Offset(1, 0) Loop worksheets("TargetSheet").Protect password:="password" End Sub
Bookmarks