Paste a value in the next empty cell for a defined range

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.

Please Login or Register  to view this content.

Thanks,
Aadesh

Got it!

Please Login or Register  to view this content.