How do I get the content of the cell left of the active cell?
 

I want to drive the execution of my macro based on the user's entry into the
cell adjacent to the left of the current cell. How do I get the content of
that cell? I see several ways of getting the current cell's content, but
nothing on how to move relative to the current cell.

How do I get the content of the cell left of the active cell?
 

ActiveCell.Offset(0, -1).Value
--
Gary's Student


"TimK" wrote:

I want to drive the execution of my macro based on the user's entry into the
cell adjacent to the left of the current cell. How do I get the content of
that cell? I see several ways of getting the current cell's content, but
nothing on how to move relative to the current cell.