Hi - I just wondered if there is a way of shortening this code down (loop it?)?
I want to apply this code to rows 4:43 but excluding rows 8,9,19,20,27,28,40,41
If Range("AM4").Value = "E" Then
Range("P4:S4").Value = "Lunch"
Range("T4:W4").Value = ""...