Like this?Does anybody know ho to assign a cell to a variable in excel?
Dim Var As String
Var = [A1].Value
MsgBox Var
Dim Var As String
Var = [A1].Address
MsgBox Var
As far as I know (providing I understand what you're looking to do), no.Is there a way to do it not using some sort of macro formula?