clarksonneo
09-13-2011, 12:55 PM
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
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