For Without Next?! Help!!

  • I'm getting a For without Next error and need help finishing this code:

  • You've got a For Each Status in Statuscol line, but no Next Status line.

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

  • I suspect Target should be Status

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

  • Replace this:


    Code
    1. Range("A" & Target.Row).Copy Sheets("Summary").Cells(Sheets("Summary").Rows.Count, "A").End(xlUp).Offset(1, 0)


    with this:


    Code
    1. Sheets("Summary").Cells(Sheets("Summary").Rows.Count, "A").End(xlUp).Offset(1, 0).Value = Range("A" & Target.Row).Value

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why