Hi,

If I want the value of cell A1 to be e, then the following code is correct.
Range("a1").Value = Range("e1").column

My question is that
If I want the value of cell A1 to be 5, what is the correct code?

I know that range("a1").value="e" is fine, but I have reason that requires the code has the form I need.
Ie, Range("a1").Value = Range("e1").??????

Thanks