VBA commands for multiple cells?

Hi JLoKyM..

Please use code tag for Codes.. otherwise it really hard to read.. and you may also get an idea that.. "No One knows the answer.."

BTW.. try this..

Private Sub Worksheet_Change(ByVal Target As Range)
Dim rngDV As Range
If Target.Count > 1 Then GoTo exitHandler
On Error Resume Next
Set rngDV = Cells.SpecialCells(xlCellTypeAllValidation)
On Error GoTo exitHandler
If rngDV Is Nothing Then GoTo exitHandler
    If Intersect(Target, rngDV) Is Nothing Then
        'do nothing
    Else
        Application.EnableEvents = False
        Select Case Target.Address
            Case "$D$8", "$D$13", "$D$18", "$D$21"
                If Target.Value = "" Then GoTo exitHandler
                    If Target.Offset(1, 0).Value = "" Then
                        Target.Offset(1, 0).Value = Target.Value
                    Else
                        Target.Offset(1, 0).Value = _
                        Target.Offset(1, 0).Value _
                        & ", " & Target.Value
                    End If
        End Select
    End If
exitHandler:
    Application.EnableEvents = True
End Sub