Hi All,

I have created a Macro to paste the values in Col A until it finds a value in Col B, but this code some what does not work, can someone rectify it.

Thanks,
Ben

Option Explicit 
 
Sub test() 
    Dim Eingabe As String 
    Dim Rw As Long 
     
    Rw = Cells(Rows.Count, 1).End(xlUp).Row 
    Do Until Not IsEmpty(Cells(Rw, 3).End(xlUp)) 
        Eingabe = InputBox("Enter a number") 
        Cells(Rw, 1).Value = Eingabe 
        Rw = Rw + 1 
    Loop 
End Sub