LinkBack URL
About LinkBacks
In my worksheet I have multiple values being replaced via VBA. Below is a piece of what I'm using. Out of curiosity can this be shortened?
If Cells(i, "B") = "600017334" Then Cells(i, "B") = "16273441"
If Cells(i, "B") = "600017340" Then Cells(i, "B") = "16273441"
If Cells(i, "B") = "600016206" Then Cells(i, "B") = "16273441"
If Cells(i, "B") = "600016252" Then Cells(i, "B") = "16273441"
If Cells(i, "B") = "600017302" Then Cells(i, "B") = "16273441"
Register To Reply
Bookmarks