Thread: How do I get the content of the cell left of the active cell?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default 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.
Reply With QuoteReply With Quote