Does anybody know ho to assign a cell to a variable?

[Pfeif0]

Does anybody know ho to assign a cell to a variable in excel?

 

[Peter_SSs]

Does anybody know ho to assign a cell to a variable in excel?

Like this?
MyVariable = Range("A1").Value

If not, you might like to spell out in more detail what you are trying to do.

 

[HalfAce]

Do you mean assign the value of a cell to the variable, or the address
of the cell?

To assign the cell's value, something like this:

Dim Var As String
Var = [A1].Value
MsgBox Var

To assign the cell's address...

Dim Var As String
Var = [A1].Address
MsgBox Var

If this isn't what you mean then can you explain in more detail?

 

[Pfeif0]

Is there a way to do it not using some sort of macro formula? I'm not familiar with them but was hoping I could use a basic function. Lets say I have a cell that is constantly changing due to random # generation when I pres F9...I want that variable to record what the new # has become so I can manipulate it.
Thanks,
Keith

 

[HalfAce]

Is there a way to do it not using some sort of macro formula?

As far as I know (providing I understand what you're looking to do), no.
I believe you're going to need some vba.

You might be able to do it with worksheet functions though if you just refer to
the cell in question in your formula(s)

I guess it all depends on your use of the term 'variable'.