Change the value of a cell

D

dayton

I need a formula that changes the value of one cell based on the value of
another.

If my value in A2 equals DS I want to change the value of cell M2 to match
the value of B2.
Else do not change any values.

T.I.A.

Dayton
 
S

steve

Dim cell as Range
Set cell = ???? ' Activecell, or Range("C2"), or ???
If Range("A2") = "DS" then
cell = Range("B2")
End If
 
Top