Activate first column's cell while same row

[ktab]

Hello,

Let's say that i have an x as range that this x.address is e.g. e13
I want to set new x as a13 (same row first column's cell).
Use of end(xltoleft) won't work.

Thank you
Kostas

 

[Norie]

Kostas

I'm not 100% sure what you mean but perhaps something like this?

Set x=Range("A" & x.Row)

 

[ktab]

Yes like that it's working (my first efford was like range("a" & x.row & """") but experimented as range("a" & x.row) and worked). Thank you anyway for prompt answer Norie