Hi,
I am trying to add to this "if" statement that it should only work for rows that are odd and i came up with this:
     If .Row = Odd And .Range("A" & rCell) <> "" And .Range("L" & rCell) = "" Then
'
'Rest of code
'
'
but it doesn't work.
Any ideas?