Finding the first nonblank cell in a row, from a specific position.
C.Offset(0, 5).Value = CH_FinGrp
Using this command to place a value on a sheet from within a For Selection loop.
What if the cell that this is going in is not blank? How do I tell this to search for the first nonblank cell to the right of (0, 5) and place it there??