Prev: external data not in a table
Next: isnumber search
From: BigO on 20 May 2010 17:27
how do i assign a value of a cell to a variable in a macro
From: Gary''s Student on 20 May 2010 18:00
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.
--
Gary''s Student - gsnu201003


"BigO" wrote:

> how do i assign a value of a cell to a variable in a macro
 | 
Pages: 1
Prev: external data not in a table
Next: isnumber search