Basically i'm finding the first empty cell of a row in a certain range by:
ActiveSheet.Range("C4:N4").End(xlToRight).Offset(0, 1).Select

After it reaches a certain Selection.Address it goes into an "IF" where it clears the content of that range and should paste a value in "C4" which now its empty, but instead pastes it where it left off.

Is there a way to fix this?

Thanks for any help you may be able to offer,

Maria