G Gary''s Student May 20, 2010 #2 This sets the variable: Sub dural() Dim r As Range, v As Variant Set r = Range("A1") v = r.Value End Sub to set the cell, reverse the equation.
This sets the variable: Sub dural() Dim r As Range, v As Variant Set r = Range("A1") v = r.Value End Sub to set the cell, reverse the equation.