Sub moveCellToBlankA1()
If Range("A1").Value = "" Then
Range("B1").Select
Selection.Cut
Range("A1").Select
ActiveSheet.Paste
End If
End Sub
Sub moveCellToBlankA1()
If Range("A1").Value = "" Then
Range("B1").Select
Selection.Cut
Range("A1").Select
ActiveSheet.Paste
End If
End Sub