Thread: Movement
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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