Movement

G

Guest

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
 
N

Norman Jones

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.
 
Top