Excel VBA - Do While Loop for SKU numbers : I am trying to automate my SKU numbers
I have 3 Columbs the First goes to 28, Second 6, Third 58.
I want the SKU to have a Trend like so 0{(###)col1}{(##)col2}{(##)col3}0

My Code looks like this

    Sub SKU()
    Dim x As Long
    x = 1
    i = 1
    j = 1
    k = 1
    Do While Cells(i, 1) <> ""
        Do While Cells(j, 2) <> ""
            Do While Cells(k, 3) <> ""
                Cells(x, 4).Value = Format(0, "0") & Format(i, "000") & Format(j, "00") & Format(k, "00") & Format(0, "0")
                k = k + 1
                x = x + 1
            Loop
            j = j + 1
        Loop
        i = i + 1
    Loop
    End Sub
