Change the value of a cell

  • Thread starter Thread starter dayton
  • Start date Start date
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
 
Dim cell as Range
Set cell = ???? ' Activecell, or Range("C2"), or ???
If Range("A2") = "DS" then
cell = Range("B2")
End If
 
Back
Top