Ugh nevermind.
![]()
Sub mellowmarshall() Dim x As String On Error GoTo z For Each cell In Range("A5:A50") If cell.Value = "" And cell.Offset(-1, 0) <> "" Then x = cell.Offset(-1, 0) cell.Select cell.Value = x End If Next cell z: End Sub
Ugh nevermind.
![]()
Sub mellowmarshall() Dim x As String On Error GoTo z For Each cell In Range("A5:A50") If cell.Value = "" And cell.Offset(-1, 0) <> "" Then x = cell.Offset(-1, 0) cell.Select cell.Value = x End If Next cell z: End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks