I am doing a simple for loop to loop through a range and check if a cell is empty and if it is, copy data in a cell on the row, paste it in another column one on the same row then delete the content in the cell it was copied from.
The loop runs, but never seems to trigger true on the if statement.
I have changed to if that cell = null and cell = "" and it still wont trigger. I have gone through and made sure the cells in question were empty as well and no change. What am I missing?
The loop runs, but never seems to trigger true on the if statement.
Code:
For X = LastRow To 1 Step -1
If IsEmpty("G" & X) Then
Cells(X, 2).Text.Copy
Cells(X, 4).Paste
Cells(X, 2).Delete
End If
Next X