I found the below code on EE posted by: zorvek (Kevin Jones) but it stops after the first occurence. I need this to loop to the end. Can someone let me know what is needed to make the macro copy every cell that is blank with the same details as the cell above until the end.
If Len(Selection.Value) = 0 Then
Selection.Value = Selection.Offset(-1).Value