Hi there, I am a bit weak in Excel VBA, can someone help please.
I want an IF statement, please tell me what I am doing wrong?
Example:
If Range("A1:A20").value = "25" then
Range ("B1:B20").value = "ABCD"
Else
Range ("B1:B20").value = ""
End If
Basically what I am trying to say here is if the value 25 is in any of the cells from A1 to A20 then place ABCD text in cell against it in B row or else leave blank.
Thanks
Bookmarks