I'm new to vba and I'm struggling with this little problem.
I haven't found any posts dealing with this issue though.

here is the point:

I'd like to fill every cell of a board bellow a range of datas with a specific value.
Let's say I've already got a range of datas in the column A , I'd like, in the same column, the line after the last cell filled with "a" values ( that can vary) fill the next empty cells with a specific value ( "b").

Here is an example of what I'd like to do as a final result;

| column A |
| --- |
| a |
| a |
| a |
| a |
| a |
| a |
| b |
| b |
| b |
| b |
| b |

I tried to code it but as soon as I launched it nothing happens, nothing changes.
Here it is ;

```
Sub test()

Dim firstlineb As Long
Dim lastlineEmpty As Long
Dim x As Integer

firstlineb = Worksheets("Sheets1").Range("A2",Range("A2").End(xlDown)).End(xlDown).Offset(1)
lastlineEmpty = Worksheets("Sheets1").Range("A2",Range("A2").End(xlDown)).End(xlDown).Offset(1).End(xlDown)

For x = firstlineb To lastlineEmpty

    Cells(x, 1).Value = "b"

Next x

End Sub

```

I'd heavily appreciate your help. Thank you a lot !