Activate first column's cell while same row

ktab

Well-known Member
Joined
Apr 21, 2005
Messages
1,297
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
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,831
Office Version
  1. 365
Platform
  1. Windows
Kostas

I'm not 100% sure what you mean but perhaps something like this?
Code:
Set x=Range("A" & x.Row)
 

ktab

Well-known Member
Joined
Apr 21, 2005
Messages
1,297
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
 

Watch MrExcel Video

Forum statistics

Threads
1,109,158
Messages
5,527,137
Members
409,749
Latest member
esmarques

This Week's Hot Topics

Top