i need help getting this code to paste in next empty cell to right.
the code only paste in column B. i need-if column B is not blank then use next cell to right.
Dim ThisCell1 As Range
Dim ThisCell2 As Range
Application.ScreenUpdating = False
For Each ThisCell1 In...