Good day,

I'm very new to coding and completely brand new to coding stuff with vba macros. After discovering the usefulness of vba in excel, I am now making a effort to learn more about it. Any help or assistance would be very much appreciated. 

This is the code I am working with so far:

```
Option Explicit

Const initrow As Integer = 3
Const ENDROW As Long = 65536
Const PrimaryLengthCol As Integer = 1 '"A"

Sub Test()

    Dim lastrow As Double
    Dim i As Double
    Dim irow As Double

    lastrow = Cells(Rows.Count, "A").End(xlUp).Row

    Application.ScreenUpdating = False

    irow = 0
    i = 0
    For i = 0 To lastrow
        If Cells(initrow + irow, PrimaryLengthCol + 2) = "BLANK" Then
            Continue For
            Cells(initrow + i, PrimaryLengthCol + 3).Value = Cells(initrow + irow, PrimaryLengthCol + 2).Value
        End If
    Next

End Sub

```

So essentially the problem I'm encountering is the following:

I have the following in Column "A" (Input column):

* 0
* 14.155
* 14.128
* 15.589
* BLANK
* BLANK
* BLANK
* 15.158

I need the vba code to LOOP through each cell and if the cell is equals to "BLANK" (text string) then the corresponding cell would take the subsequent number. In addition, if the value from column "A" is equal to zero then output is equal to "void" in column "B". 

So the desired output in column "B" (Output Column) would need to be:

* Void
* 14.155
* 14.128
* 15.589
* 15.158
* 15.158
* 15.158
* 15.158

The last criteria is that if the cells in column "A" equal to "BLANK" was preceded by a zero value in the previous cell than those "BLANK" would also equal to a "void" value in the output column "B" :

So if Column "A" had this scenario:

* 0
* BLANK
* BLANK

Output Column "B" needs to be:

* void
* void
* void

I'm unsure of how to apply the Continue For since I want the loop to "skip" over the "BLANK" cells for the next iteration, but still fill the corresponding value into the "B" column with the subsequent qualifying value. I would prefer to complete this via vba, because once again I am trying to learn the language so I am forcing myself to increase my exposure to it.

Once again any assistance on the matter would be highly appreciated. 

Thank you!