Hello,
I am trying to code the logic mentioned below but I am not able to get it right.
True for Range B25 to B30
1) Start at B25
2) If cell is empty then value = value from cell CB97, stop the macro
3) If cell is not empty then move to next row and repeat Step 2.

As a test I was trying to get this code working but did not get it right. I was hoping to get the code to start at Cell CF96 but it starts at CF2. column CF is empty when I run the macro. 
Range("CB97").Copy Destination:=Range("CF96").End(xlUp).Offset(1)

Thanks,
Aadesh