Forum Discussion
BVA: FillDown until empty cell
Hi everyone! I know this is a straight forward answer but I am completely stumped! I will lay out my problem to best explain my issue: In column C on my file, any cell in this col containing ...
Do you want to process for example column D as it is shown in attached file? I wrote easy VBA code to perform this task. The "0" values are replaced by the column header until there is no entry left in column D.
Sub headline()
Dim i As Integer
For i = 2 To 100
If Cells(i, 4).Value = "" Then
Exit Sub
End If
If Cells(i, 4).Value = 0 Then
Cells(i, 4).Value = Cells(1, 4).Value
Else
End If
Next i
End Sub