Movement
 

Hello,

How can I move to the cell in column "A" on the row that I
am currently on. I want to be able to move to column A
from any row and the row will change.

Looking for something like:

Range("A" & Row).select

This doesn't work, but is something similar possible

Movement
 

Hi,

Try:
Cells(ActiveCell.row, 1).Seleect

or

ActiveCell.EntireRow.Cells(1).Select


However, you rarely need to physically select a cell. Most operations can be
effected by referring to the cell.


---
Regards,
Norman



wrote in message
...
Hello,

How can I move to the cell in column "A" on the row that I
am currently on. I want to be able to move to column A
from any row and the row will change.

Looking for something like:

Range("A" & Row).select

This doesn't work, but is something similar possible

Movement
 

Typo warning:


Cells(ActiveCell.row, 1).Seleect

Should read:

Cells(ActiveCell.row, 1).Select

---
Regards,
Norman