Solved: Range("e1").Row = 5 not e

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

I guess that you don't mean

[vba]Range("A1").Value = 5[/vba]

not clear.
i you are wanting to populate A1 with the column letter of a cell then
[VBA]Range("A1").Value = Left(Range("E1").Address(1, 0), InStr(1, Range("E1").Address(1, 0), "$") - 1)
[/VBA]

Quote:

---

Originally Posted by mancubus

not clear.
i you are wanting to populate A1 with the column letter of a cell then
[vba]Range("A1").Value = Left(Range("E1").Address(1, 0), InStr(1, Range("E1").Address(1, 0), "$") - 1)
[/vba]

---

thank you this is exactly what I need.

I have to say sorry, because the title of this thread is wrong.
The correct one is
range("e1").column = 5 not e

you're wellcome.

please mark the thread as "solved" from "Thread Tools" dropdown on top of the page.